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