After analyzing TCP/IP (TNS) or ODBC tracelog you can tell:
- this problem is in ODBC driver
- this problem is in VFP
- this problem is in ORACLE
How is ORACLE's version?
How is save PLAN for this query in SGA Cache?
MartinaJ
>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) ..