Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement