getObject() - Mailing list pgsql-jdbc

From Antonio Fiol Bonnín
Subject getObject()
Date
Msg-id 3BAB5C1C.CD900622@w3ping.com
Whole thread Raw
Responses Re: getObject()
List pgsql-jdbc
Hi,

I have a very poor performance on a slow network. Because of the slow
connection... you'll say. Please read more.

When looking at the traffic that is going in and out of my machine, I
see many (a real lot of) times the same request. Something like:

select typname from pg_type where oid = XXX

where XXX is a number (23, 1184, or maybe others)

As I use the getObject method to retrieve the different ocjects
contained in the resultset (I can't tell whether it's going to be an
number or a timestamp beforehand), I imagine that this select statement
is the one that helps getObject choose the right type. But, as every row
in the resultset will have the same column types, couldn't some caching
accelerate everything a lot?

I have tried to connect to CVS, but instructions on
http://www.ca.postgresql.org/devel-corner/docs/postgres/cvs.html
did not work for me. I got:
cvs login: authorization failed: server postgresql.org rejected access
to /home/projects/pgsql/cvsroot for user anoncvs

If you have ideas on the subject, or maybe instructions on downloading
the latest CVS version, please tell me.

Thank you very much.

Antonio Fiol
W3ping

pgsql-jdbc by date:

Previous
From: Denis Bucher
Date:
Subject: URGENT ! Nouveau virus
Next
From: Rene Pijlman
Date:
Subject: Re: getObject()