Re: Re: JDBC Performance

Where can I get the source code for the JDBC driver? I'd like to see
the kinds of changes you guys are making.

-Keith

-----Original Message-----
From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: Gunnar R|nning <gunnar(at)candleweb(dot)no>
Cc: kientzle(at)acm(dot)org <kientzle(at)acm(dot)org>; PostgreSQL general mailing list
<pgsql-general(at)postgresql(dot)org>; Keith L. Musser <kmusser(at)idisys(dot)com>
Date: Monday, October 02, 2000 4:59 AM
Subject: Re: [GENERAL] Re: JDBC Performance

>On 29 Sep 2000, Gunnar R|nning wrote:
>
>> Tim Kientzle <kientzle(at)acm(dot)org> writes:
>>
>> >
>> > A custom converter may not really help; I experimented with that
for
>> > another project and it really didn't make that big of a difference.
>> >
>> > You might get some advantage by manually handling the converter
object,
>> > keeping a reference to it in the database handle so you don't have
to
>> > re-instantiate that class every time. That might help.
>>
>> Yup, this actually seems to take more time than the conversions
themselves
>> at the moment according to how OptimizeIT presents my application
run.
>>
>> > a statement, convert just the arguments into bytes and emit the
>> > complete statement.) I've had very good luck with this strategy
>> > for building and caching mostly-static web pages within Java
servlets.
>>
>> Good tip, but I think the next big leap in performance would be to
improve
>> the speed of the ResulSet get methods.
>
>For JDBC2, I'm planning (may get done for 7.1) an alternate ResultSet
>class that uses cursors. This would speed things up as the entire
>resultset isn't received in one go. That's the biggest bottleneck of
them
>all.
>
>Peter
>
>--
>Peter T Mount peter(at)retep(dot)org(dot)uk http://www.retep.org.uk
>PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
>Java PDF Generator http://www.retep.org.uk/pdf/
>
>
>