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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only