Re: ODBC vs Pro*c or OCI

Hi! Folks:

We are using 8.1.5 Oracle ODBC driver and just today we noticed a problem. We have a multi-threaded NT application where each thread basically opens a connection to the database and calls a stored procedure.

We noticed that all these threads are getting serialized on SQLExecDirect() call. Is Oracle ODBC multi-threaded? We were wondering if we have to set some connection attributes.

[Quoted] OCI documentation claims (though we have not tried it yet) that it supports multi-threading and Oracle ODBC is supposed to have been implemented using OCI.

Could you please shed some light on the matter? We are eager to know what is the solution to the problem.

Any help would be really appreciated.

Thanks a lot for your time.

regards,
premal
mumbai,
india

In article <37938010.85F41FD_at_home.com>,   khanf_at_home.com wrote:
> Folks, I am building a very high performance
> distributed application for the internet. I have a
> minimum requirement of at least 400 transaction/s (profiled on
> low end solaris box).
>
> What are the pros and cons of using ODBC vs pro*c or OCI ?
> I am interested in performance issues/experiences using
> ODBC. How is connection pooling in Oracle ODBC driver ?
> Are there any gotchas with ODBC for high performance
> solutions ?
>
> Can I use Oracle Advanced Queuing with Oracle ODBC ??
>
> Any ideas, suggestions appreciated. I can be mailed directly
> also.
>
> Thanks in advance.
>
> Regards.
> Furkan Khan
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 17:31:01 CEST