SQL PT dataset (variable no of records but within a range of records) >INDEX on a field > >SCAN > SEEK(in "MySQLPTCursor") > Do other stuff >ENDSCAN>
>SCAN > SQL PT single record as needed > Do other stuff >ENDSCANGenerally, the most expensive thing in SPT is the overhead of a single SqlExec (if we discount for bad database design, or other human factor issues). If your code needs to perform a lot of work on multiple records, get those records at once, and trust the Fox to do most of what you do (in case 1) in memory. The second case would require one trip to server for each record, which would create much more network traffic.