Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing on views
Message
 
À
16/08/2000 11:33:25
Sergio Ortiz
Tek Services Group, Llc
Hollywood, Floride, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00405520
Message ID:
00405555
Vues:
14
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform