Hi!

Probably because you use a parameter in the query. Parametrised query could not be prepared at the server side, as far as I know. This is only for static queries.


>Hi J. Flores!
>
>My friend make tests... Take a look:
>
>

>* Test ONE
>t1 = seconds()
>FOR x = 1 to 8000
>   codigo_cliente = x
>   SQLEXEC(sql_connection,"Select * FROM authors WHERE codigo
>=?codigo_cliente","tmpCursor")
>NEXT x
>wait window transform(seconds() - t1)
>* Test TWO
>t1 = seconds()
>sqlprepare(sqlserver_handle,"Select * FROM authors WHERE codigo
>=?codigo_cliente","tmpCursor")
>FOR x = 1 to 8000
>   codigo_cliente = x
>   SQLEXEC(sqlserver_handle)
>NEXT x
>wait window transform(seconds() - t1)
>

>
>So... The results:
>
>just SQLExec = 7,291 seconds
>SQLPrepare + SQLExec = 7,631 seconds
>
>Why?... :-)