On Friday, January 3, 2003, at 09:12 AM, Jeff wrote:
> Hmm.. This won't fix the fact the planner takes three seconds, but
> since
> it is a web application have you tried using PREPARE/EXECUTE so it only
> needs to be planned once?
Interesting point. I'd have to look into the source code whether the
guy who wrote it actually uses JDBC PreparedStatements. I understand
that PostgreSQL from 7.3 onwards supports prepared statements (cool!).
Would the JDBC driver accompanying the dist. exploit that feature for
its PreparedStatement implementation?
-hilmar
--
-------------------------------------------------------------
Hilmar Lapp email: lapp at gnf.org
GNF, San Diego, Ca. 92121 phone: +1-858-812-1757
-------------------------------------------------------------