Speed between ODBC and Embbded SQL

Hello,

I am asking why à Embdded SQL Code (Proc) are very fast and the same query in ODBC are so slow ?

The query recive by oracle are :

For ODBC :

SELECT agent.pwd

    FROM agent
    WHERE upper(agent.mnemo)='TSX'

For Embdded SQL :

SELECT agent.pwd

    INTO :b0
    FROM agent
    WHERE upper(agent.mnemo)=:b1

Thanks
LeguMan Received on Sat May 12 2001 - 03:26:36 CDT