>>>Hello!
>>>
>>>I try to browse a 500000 records table in VFP 5.0a(at command ligne with the commande "browse"). Do you know why is so long before the browse appeared. it takes arround 45 seconds.
>>>
>>>I try it in FPW2.6 with the same table and it is instanly.
>>>
>>>Hope that you can answer me
>>>Thank's in advance
>>
>>do you have a index tag on deleted()? try set deleted off and / or
>>remove the deleted tag. You should see a world of difference...
>
>
>Yes your right !!!
>
>Can you explaine that know ?

I know this happens in VFP but did not in FPW. You can reapply
the deleted tag and do a BROWSE NEXT 100 records and have instantaneous
response time. My understanding is that VFP is pulling down a bitmap
of the deleted tag to your local hard drive or your tempfile setting.
To verify this with NT 4.0, apply the deleted tag then do a browse.
Click on start | programs | Admin Tools | Windows NT diagnostics.
Click on the network tab and then keep hitting the statistics button.
you will see that a large number of bytes are being pulled down to
your workstation assuming tmpfiles is on your local drive.

Perhaps someone else can better elaborate on why this is happening.
The theory used to be to ALWAYS add an index tag on deleted. For the
reason you and I experienced (plus I have very few deleted records) I
no longer do that. Guess not too many people working with large 500K
tables or you would see this question occur more frequently.