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

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 (view raw, whole thread or download thread mbox)
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

pgsql-jdbc by date

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

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