Skip site navigation (1) Skip section navigation (2)


From: Antonio Fiol Bonnín <fiol(at)w3ping(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: getObject()
Date: 2001-09-21 15:26:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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
did not work for me. I got:
cvs login: authorization failed: server 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


pgsql-jdbc by date

Next:From: Rene PijlmanDate: 2001-09-21 18:01:10
Subject: Re: getObject()
Previous:From: Liam StewartDate: 2001-09-20 20:24:45
Subject: JDBC test suite patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group