Re: Difference between Oracle OCI and thin Driver?

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Thu, 20 Jan 2005 13:28:51 -0800
Message-ID: <41F02293.3010407@bea.com>

yong321_at_yahoo.com wrote:

>>Originally the OCI driver was faster, but in recent years this
>>has been fixed, especially for the 10g version of the thin
>>driver. OCI has evolved too, but bugs in native OCI code can
>>still kill an entire JVM, whereas the thin driver is completely
>>safe in that regard.

>
>
> Hi, Joe,
>
> Could you please elaborate? Or point me to some documents on the
> Internet? I heard OCI driver was much faster than thin. But it looks
> like those benchmarks were outdated. Thanks.
> Yong Huang
> yong321ATyahoo.com

Hi. There is no standard benchmark. We did significant testing and found a big improvement in the 10g driver. We have made and sold our own OCI-based driver since '96. It was the first JDBC driver for Oracle. Perhaps *because* of our familiarity with OCI, we avoid it and prefer the all-Java option. Your mileage may vary, so do your own tests. If OCI works well for you, go for it...

Joe Weinstein at BEA Received on Thu Jan 20 2005 - 15:28:51 CST