>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.
It is very hard to say w/o proper testing. I would vote for second if you first issue SQLPREPARE() to prepare your query first and then in loop just change parameters and issue SQLEXEC(), BUT as I said, I am not so sure that this is the faster way.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.