Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ARGHH! big table killing VFP - need strategy help!
Message
From
01/09/1999 01:39:28
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00250826
Message ID:
00260029
Views:
23
Stephen,

Can this be due to a lot of deleted records at the begining of the table? As we know VFP (and FP for that matter) caches a number of records when opening the table. I could imagine that if SET DELETE = ON VFP doesn't count the deleted records and has to download additonal records. This might be a sitiation where the deleted tag is handy.

Also did you open the table shared or Exclusivly ? VFP downloads more reads if you open the table exclusive. Did you open the table with or without setting an index order (For example: USE Table ORDER Tag) ?

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform