Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I have been debating on child records, whether to SELECT the related records or SEEK and SKIP through them.
I have always regarded the SEEK as the fastest method, but have usually run SELECT INTO CURSOR, and then SCAN the cursor.
I ran a simple test and the SELECT came out quicker - can this be right.
Here are my 2 methods:
*** SEEK Method ***
SELECT ChildTable
IF SEEK(ParentTable.PriKey)
DO WHILE ChildTable.ForKey = ParentTable.PriKey
**** Some Code Here ****
SKIP
ENDDO
*******************
*** SELECT Method ***
SELECT * FROM ChildTable;
WHERE ForKey = ParentTable.PriKey;
INTO CURSOR Cursor1
SELECT Cursor1
SCAN
**** Some Code Here ****
ENDSCAN
*********************
Could someone advise me if this is correct - why would the SEEK be slower if the SELECT has to input the Query into a CURSOR and then SCAN?
Replies much appreciated
Thanks
Kev
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