>>>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
>>
>>Rock,
>>
>>You have SET DELETED ON? Do you have an index on DELETED()?
>
>Hi Jim
>
>Yes i have one. Cant you explain why when i'm on SET DELETED ON it's very slow and when i'm on SET DELETED OFF it's ok...

Hi Rock,

This is just a guess, but maybe VFP tries do determine how many records there are to display in the table, to set the height and position of the vertical scroll bar. When set deleted is OFF, this is just the number of records. With set deleted ON, he must take a look at the index to find out how many are not deleted, which may take some time. (As I said, it's just a guess.)

You may try to reindex, and see if it is any faster.

Marc Van Riet