>>>I have 6 SQL command in a prg to retrive data into a cursor from 3 tables(with 9000,180,000 and 340,000 records). When I run the prg from project manager, it takes 37 secs. If I run it in the Form.Load(), it takes 60 secs. What is the possible cause?
>>>
>>>TIA
>>>
>>>S H
>>
>>some settings like SET DELETED ON/OFF can have an influence, if you don't have an index on DELETED()
>>Just a guess.
>>
>>Christian
>
>Christian,
> I don't have any deleted record in the tables. Is SET DELETED releated in this case? I will check the environment settings difference between runtime and development.
>
>Thanks,
>S H
I doesn't matter if you have deleted records or not. If SET DELETED is ON, Foxpro will have to check for deleted records anyway.
Christian Desbourse ( Belgium )