| From: | Hilmar Lapp <hlapp(at)gmx(dot)net> |
|---|---|
| To: | Jeff <threshar(at)torgo(dot)978(dot)org> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: join over 12 tables takes 3 secs to plan |
| Date: | 2003-01-03 19:38:50 |
| Message-ID: | FC24BF36-1F52-11D7-9CCF-000393B4BFF6@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-performance |
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
-------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles H. Woloszynski | 2003-01-03 19:53:26 | Re: [GENERAL] 7.3 Prepared statements |
| Previous Message | Barry Lind | 2003-01-03 19:33:41 | Re: [GENERAL] 7.3 Prepared statements |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Wolfe | 2003-01-03 20:49:33 | Re: Question on hardware & server capacity |
| Previous Message | scott.marlowe | 2003-01-03 18:06:38 | Re: Question on hardware & server capacity |