Re: jdbc performance in Solaris

>
> I suggest you try setting the following environment variables and
> restart your Java application (the second one is needed if your
> application is 64-bit; if not, setting it is harmless):
> export LD_LIBRARY_PATH=/usr/lib/lwp
> export LD_LIBRARY_PATH_64=/usr/lib/lwp/64

>
> Please let us know if you find anything. If you find Bobby's suggestion
> (below) works, also let us know. Thanks.
>

Well, nothing new around here. Bobby's suggestions and yours haven't improved the performance.
I'm not sure if the threading model of java is really an issue; the problem is in fact the performance of a single java.sql.Connection object, running in a single thread.

When I launch several instances of the test program several times, or a multithreaded version, oracle is able to absorb the load; what I found strange is the "factor" difference between Windows and solaris. As a reminder, in Windows, the connection with autocommit on is around 1.5 times slower (400 insertions/second without autocommit, 250-300 with autocommit), whereas in solaris, this factor may go up to 10 (440 / 44).

The test program and the JDBC drivers version are the same. That's why I think it's more OS or Oracle related, and not Java related. I've tried with different JDBC drivers versions (9.0, 9.2, 10), and the results are the same.

Well, thanks for your support. Received on Wed Jan 19 2005 - 04:24:30 CST