ResultSetMetaData performance

From: "Mark De Souza" <mark(at)openobjects(dot)com(dot)au>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: ResultSetMetaData performance
Date: 2007-02-18 06:12:37
Message-ID: 000401c75323$cbe71bb0$5500a8c0@ronin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2007-02-18 23:40:53 Re: Max size for bytea type
Previous Message santosh dwivedi 2007-02-17 20:45:16 unsubscribe