Sorry, I missread your pseudocode. I expect that it'll faster to get all records at once into SPT cursor and than process them than fetch them one by one. As Tore correctly pointed out, only test can tell wich one will be faster in practice.
>
>>The second one is missing SEEK() to find record in the local cursor.
>
>I am scanning the local cursor, it does not require a seek I want to do all records. For each record I will bring a record from SQL based on a PK/FK. A Parent (SQL) -Child (Local) kind a thing.
>
>>Assuming that MySQLPTCursor has less records that local cursor, I would expect the second one to be a little bit faster. Depending on the # of records in the cursor, the difference may be negligible.
>
>Oh, okay.
>
>Thanks.
--sb--