[Opensource] Performance Question

[Michael Rimov]

Hey All,

I was wondering if somebody had some stats on something.  Many people have 
been requesting prepared statements for performance reasons.  As far as 
Expresso's DBConnection works, I'm not sure how much use it would be since 
prepared statements are dependant on a single connection and the point of 
DBConnection/DBConnectionPool is releasing the connection as soon as you're 
through.

I've read that supposedly some databases will cache the query plan and thus 
you could get some performance improvements that way.  But what I'm 
wondering is... does anybody have any real experience with this and any 
empirical data to show that this really is a performance booster? 
[Especially when used in conjunction with a Connection Pool, JNDI or otherwise]

Any citations would be greatly appreciated.

Thanks in advance!
						-Mike