ResultSetMetaData performance - Mailing list pgsql-jdbc

From Mark De Souza
Subject ResultSetMetaData performance
Date
Msg-id 000401c75323$cbe71bb0$5500a8c0@ronin
Whole thread Raw
List pgsql-jdbc
Hi all,

I'm just wondering when the feature below will be implemented. Its pulled
from the todo list on the postgres jdbc website.

"ResultSetMetaData calls that run queries are cached on a per column basis,
but it seems likely that they're going to be called for all columns, so try
to issue one query per ResultSet, not per column."

Currently frameworks like sun java creator and netbeans visual web pack make
heavy use of the metadata of queries. This usually is not a problem but in
the current implementation it means that if your query is returning 30
columns you are actually running 31 queries instead of 2. Suffix it to say
that this can bring your queries to a crawl.


Thanks in advance,
Mark De Souza


pgsql-jdbc by date:

Previous
From: santosh dwivedi
Date:
Subject: unsubscribe
Next
From: Kris Jurka
Date:
Subject: Re: Max size for bytea type