Re: Speed between ODBC and Embbded SQL

[Quoted] "LeguMan" <vgi_at_sgms.sema.be> wrote in message news:3afcf1f2$0$3121$456d72a3_at_news.skynet.be...
> 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
>
>

You are comparing apples and pears.
ODBC is a generic product, interfacing to theoretically, any database. Hence [Quoted] ODBC has it's own dll's and runs on top of sqlnet. Pro*C directly interfaces to sqlnet.
[Quoted] ODBC needs to translate to native Oracle calls. Also, any function not supported by Oracle directly, will force the query to [Quoted] run on the client completely.

If you are using ODBC in conjunction with VB or Visual ++ you might consider using Oracle Objects for OLE,
[Quoted] This is DAO like interface to Oracle, and it interfaces directly to sqlnet.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat May 12 2001 - 13:12:19 CEST