General information
Category:
Forms & Form designer
>>>Just a minor note: there are certain situations when SEEK/SKIP cursor will be blazingly faster than p-view, even full Rushmore optimizable.
>>
>>Edward --
>>
>>Interesting note. I would like to understand it a little better. Is this because the view is based on SQL SELECT, while using SEEK and SKIP would work directly on the cursor? Or...?
>>
>>Thanks -- Bill
>
>Yes, SEEK/SKIP/INSERT INTO CURSOR will work much faster (much may mean 5-6 sec on slow machines) than SELECT_SQL running against big table (let say >300K recs) located on network, when SET DELETED ON.
I can see where that would definitely make the grid snappier, but wouldn't it take some additional time to update the child table from the cursor?
Thanks again -- Bill
Previous
Next
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