Also, check the SET OPTIMIZE status.
Vlad
>>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
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