Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing on views
Message
 
To
16/08/2000 11:33:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00405520
Message ID:
00405555
Views:
13
>Hello Bret,
>
>I was thinking to use local views in my forms.
>
>
>The .exe and the database is stored in a server (f:\apps\incentive).
>Remote branches are accesing the .exe and database. Currently my forms are using tables and filters( set filter to ). I went to a branch to test the application and it was taking about 10 minutes to display a form and 6 minutes to display reports that uses a local view agains a table ( sales.dbf).
>The branch has a bellsouth connection of 256K.
>
>This is really slow.!!!!
>Any suggestion to speed up the application????. Should I use a different installation. Mayby install the .exe at the branch server location......any advice!!!
>
>Thanks,
>Sergio

Is the filters you are setting on tables that have indexes on the fields you are filtering on?
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Reply
Map
View

Click here to load this message in the networking platform