Horton

Re: join over 12 tables takes 3 secs to plan

Hilmar Lapp <hlapp@gmx.net>

View thread View on postgr.es
From: Hilmar Lapp <hlapp@gmx.net>
To: "Charles H. Woloszynski" <chw@clearmetrix.com>
Cc: Jeff <threshar@torgo.978.org>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2003-01-03T22:22:49Z
Lists: pgsql-performance 
On Friday, January 3, 2003, at 02:16  PM, Charles H. Woloszynski wrote:

> Also, you need to retain the PreparedStatement, it is not cached based 
> based on the text of the
> statement, but associated with the PreparedStatement itself

I think that's normal. I don't recall the JDBC spec saying that you 
have a chance the server will remember that you created a 
PreparedStatement for the same query text before. You have to cache the 
PreparedStatement object in your app, not the query string.

BTW that's the same for perl/DBI. At least for Oracle.

	-hilmar
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------