Re: join over 12 tables takes 3 secs to plan

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