Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Techniques for querying lookup table data.
Message
From
22/01/1999 15:08:01
 
 
To
22/01/1999 14:58:26
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00179173
Message ID:
00179201
Views:
27
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform