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
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 |