Re: JDBC performance

"Keith L. Musser" <kmusser(at)idisys(dot)com> writes:

> I was hoping the client-side overhead would be less.
>
> (a) Any hints on getting good performance when using JDBC?

Well. I'm usually caching objects on the Java side for frequent queries.

> (b) How much better is the client-side overhead if I were using C
> instead of Java?

Possibly, but I doubt it would do to much. I think the JDBC driver could be
tuned to perform better though. I noticed for instance that the conversion
step from byte to char is taking up considerable time compared to executing
and getting the raw query result. I run the JDBC driver through the
OptimizeIT profiler and found that a lot of the overhead was in the
interpretation of the returned result. ReceiveString and ReceiveTuple where
clear bottlenecks.

> (c) Do many of you use Java to access PGSQL?

Yup. We have been deploying 3 different web applications for our clients
using servlet technology and Java to access PostgreSQL. We are however
using the 7.0.2 release of PostgreSQL.

Regards,

Gunnar