>Hi all
>
>What is more efficient:
>
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
>ENDSCAN
>
>Please advise.
With an exclusive environment the first is faster and cleaner.
With a not exclusive ( multiuser ) env.
the two ways are completely different, and therefore it doesn't have sense compare they.