Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed up
Message
 
 
To
20/05/2003 05:57:10
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00790246
Message ID:
00791002
Views:
20
If you open your database with deleted on, if there are lots of deleted records at the beginning of the table, this will cause a delay as Foxpro will search to the first undeleted record.

You can speed this by setting up a CDX on deleted(), then Foxpro will use the index to go quickly to the first record. There has been different views on if this really speeds things up or not in different situations, anyway, if there's at least 10% of deleted records i'd say its best to do it.

Obviously, avoid commands that don't use Rushnmore like GO TOP

Hope this helps,
Rob
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform