>Hi,
>I think, this is not Oracle or Oracle driver problem, but somewhere in vfp,
>
>private pnID
>pnID=10
>
>with Microsoft driver:
>sqlexec(,"select * from blabla where id=?pnID")
>or
>sqlexec(,"select * from blabla where id="+transform(pnID))
>give the same speed
>
>but with Oracle is the speed with "=?pnID" option much slower (100x) ..
I am wondering if the problem is in the wrong implicit conversions. Say, in SQL Server it may be a problem if column is defined as varchar and the parameter is defined as nvarchar or if column is defined as int and the parameter is defined as bigint.
In SQL Server it's easy to run a trace.
If it's not broken, fix it until it is.
My Blog