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?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement