Re: Re: JDBC Performance - Mailing list pgsql-general

From Peter Mount
Subject Re: Re: JDBC Performance
Date
Msg-id Pine.LNX.4.21.0010021203560.420-100000@maidast.demon.co.uk
Whole thread Raw
In response to Re: Re: JDBC Performance  ("Keith L. Musser" <kmusser@idisys.com>)
List pgsql-general
On Fri, 29 Sep 2000, Keith L. Musser wrote:

> I'm thinking caching byte arrays on a per-connection basis is the way to
> go.
>
> However, how much difference do you expect this to make?  How many byte
> arrays to you allocate and destroy per SQL statement?  And how big are
> the arrays?  How much memory will they occupy per open connection?
>
> Will this really make a big difference?

It should. Everything that goes between JDBC and the backend is converted
into byte[] arrays, so it does occur, and occur often.

Peter

[snip]

--
Peter T Mount peter@retep.org.uk http://www.retep.org.uk
PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
Java PDF Generator http://www.retep.org.uk/pdf/



pgsql-general by date:

Previous
From: Peter Mount
Date:
Subject: Re: Re: JDBC Performance
Next
From: Peter Mount
Date:
Subject: Re: Re: JDBC Performance