Hi Pavel,

What is structure of table uVuz?
What is Oracle version? (11.1.0.2,11.1.0.6,11.1.0.7)

MartinaJ

>Hi,
>I found nothing,
>here is code, time is average of several attempts (with tracing off), sql.log included,
>database Oracle 11g,
>
>

>
>private pnID
>pnid=346119
>
>SqlDisconnect(0)
>lcD="{Oracle in OraClient11g_home1}"
>lnH=SqlStringConnect("Driver="+lcD+";UID="+lcUser+";PWD="+lcPass+";Dbq="+lcServer+";")
>ss=seconds()
>SqlExec(lnH,"select * from uVuz where uVlakID=346119")
>?seconds()-ss
>*0.010 sec, 28 records
>
>SqlDisconnect(0)
>lnH=SqlStringConnect("Driver="+lcD+";UID="+lcUser+";PWD="+lcPass+";Dbq="+lcServer+";")
>ss=seconds()
>SqlExec(lnH,"select * from uVuz where uVlakID=?pnid")
>?seconds()-ss
>*0.744 sec
>
>SqlDisconnect(0)
>lcD="{Microsoft ODBC for Oracle}"
>lnH=SqlStringConnect("Driver="+lcD+";UID="+lcUser+";PWD="+lcPass+";Server="+lcServer+";")
>ss=seconds()
>SqlExec(lnH,"select * from uVuz where uVlakID=346119")
>?seconds()-ss
>*0.014 sec
>
>SqlDisconnect(0)
>lnH=SqlStringConnect("Driver="+lcD+";UID="+lcUser+";PWD="+lcPass+";Server="+lcServer+";")
>ss=seconds()
>SqlExec(lnH,"select * from uVuz where uVlakID=?pnID")
>?seconds()-ss
>*0.014 sec
>
>