Asyncronous it is slower intrinsically.

But the true thing that renders all the slowest one visibly is the fact that inner VFP uses window messages like trigger for reading ODBC data
(test to you to quickly move the mouse during the unloading).

You can force it with a

GO lastRec+500
lastRec=recno()

into the cycle.

On VFP9 a new cursor property can simplified the task.

Fabio

>Hi Folks!
>
>To show the User response while a big SPT query, I made an Asynchronous SPT Connection. Bud now the Query takes much more Time than before?! Whats wrong?
>
>

>sqlsetprop(lnConnectionHandle,'Asynchronous', .T.) = 1
>	>store 0 to lnZaehler, lnAnzahl, lnModulo
>lnModulo = 60
>	>* SQL Komando schicken
>lnOK = sqlExec(lnConnectionHandle, tcSQLStatement, tcCursorname)
>
>do while lnOk = 0			
>   lnOK = sqlExec(lnConnectionHandle)
>   lnZaehler = lnZaehler + 1
>		>  if mod(lnZaehler,lnModulo)=0
>     lnAnzahl  = 0
>  else
>     lnAnzahl  = lnAnzahl + 1
>  endif
>		>  set message to "Abfrage wird ausgeführt "+replicate(chr(19),lnAnzahl)
>  inkey(0.5, "H")
>enddo
>
>set message to "Abfrage beendet"
>	>sqlsetprop(lnConnectionHandle,'Asynchronous', .f.)
>	>set message to
>
>