| performance of OCI vs. thin [message #366644] |
Wed, 17 May 2000 14:42  |
Alexander
Messages: 109
Registered: May 2000
|
Senior Member |
|
|
Hi, does anyone have advice on the performance differences of JDBC OCI drivers vs. thin drivers. We are running an Apache/JRun and a 8.1.5 on 2 Suns in a cluster environment. Do you think we can gain performance if we install Net8 on the machines and switch from thin to OCI?
TIA
alexander
|
|
|
|
| Re: performance of OCI vs. thin [message #366649 is a reply to message #366644] |
Tue, 20 June 2000 14:48  |
Frank Naude
Messages: 4590
Registered: April 1998
|
Senior Member |
|
|
Hi,
According to Oracle the OCI driver is the fastest. However, in my experience the thin driver beats it ever single time. Maybe you should test both and let us know your results.
Cheers
Frank
|
|
|
|
| Re: performance of OCI vs. thin [message #366660 is a reply to message #366649] |
Mon, 21 August 2000 06:21 |
Alexander
Messages: 109
Registered: May 2000
|
Senior Member |
|
|
i didn't slide by this site too often lately, that's why my reply may be late, but:
frank seems to be absolutely right.
i tested oci vs. thin in the 8.1.6 versions for NT, JDK 1.2.2, and the thin driver was (marginally) faster all the time.
(PS: the setExecuteBatch method did the trick)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
