Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Techniques for querying lookup table data.
Message
De
22/01/1999 15:08:01
 
 
À
22/01/1999 14:58:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00179173
Message ID:
00179201
Vues:
28
>We're using views in a multi-user environment. We're finding that just loading the lookup views for a form can take a fair amount of time. But, yeah, otherwise, there would be no problem requerying the data when needed.

You should investigate what actually slowdown the views. It might be few areas to look for: tag on DELETED(), Rushmore in general, too 'view-generous' design approach. The latter one means that there is no reason to use view for the purpose of e.g. populating a combo: cursor will do this job faster. Also in many situations SEEK/SKIP cursor will work faster than view as grid.recordsource.
Surely, it's question of developer's preference.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform