Re: cache of PreparedStatements - Jeff Mathis - com.mysql.lists.java

12 messages in com.mysql.lists.javaRe: cache of PreparedStatements

From	Sent On	Attachments
Jeff Mathis	19 Aug 2004 16:11
Kevin A. Burton	19 Aug 2004 18:09
Shankar Unni	20 Aug 2004 10:04
Jeff Mathis	20 Aug 2004 10:31
Jeff Mathis	20 Aug 2004 13:59
Kevin A. Burton	20 Aug 2004 15:31
Jeff Mathis	20 Aug 2004 15:39
Mark Matthews	23 Aug 2004 15:43
Kevin A. Burton	23 Aug 2004 18:34
Jeff Mathis	24 Aug 2004 08:41
Mark Matthews	25 Aug 2004 12:48
Jeff Mathis	25 Aug 2004 12:54

Subject:	Re: cache of PreparedStatements
From:	Jeff Mathis (jmat...@predict.com)
Date:	08/25/2004 12:54:31 PM
List:	com.mysql.lists.java

Jeff,

It uses server-side prepared statements, which aren't cached by the driver (currently). Many JDBC connection pools offer the ability to do this in a driver-independent way, if you really want to cache them.

-Mark

ok. so this gets me back to me original question about writing a little class to cache my prepared statements. i'll do that after i've done some more profiling to make sure its really worth it.

thanks

jeff