Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Speed - Opening Tables navigating etc.
Message
From
13/07/2000 09:59:23
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00391705
Message ID:
00391778
Views:
9
Do you have an index tag on DELETED()? If so, a bitmap image is being pulled down to your tmpfiles area. Try this -

USE table
BROWSE NEXT 1000

or get rid of the index tag on DELETED() and then BROWSE.

>>Can anything be done to increase the speed of fox opening tables, and navigating them?
>>
>>In FPW 2.6 command window,
>>use blah
>>go bott
>>brow
>>works very quickly.
>>
>>The same set of commands in VFP are quite slow, i.e. 15 secs.
>>
>>Any ideas?
>>
>>TIA,
>>Mike
>
>Sounds strange to me! I have a table with a million records, it opens in a blink of an eye. Post the exact commands, index available, how many records?
Previous
Reply
Map
View

Click here to load this message in the networking platform