-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bill,
On 10/19/2009 3:14 PM, Bill Davidson wrote: > Christopher Schultz wrote: >> I'm curious about the usefulness of caching prepared statements in >> general, though. What is the default maxOpenPreparedStatements setting >> and what did you set it to in order to get it to work out well for you? >> > > The default is unlimited, which is the problem. I've been playing with > different settings to try and find the best one, but obviously, it needs to > be less than 300. > >> If you have 100 different prepared statements in your code and you are >> only allowing a connection to cache, say, 5 of them, then I have to >> expect that you'll be constantly thrashing your cache as new statements >> are prepared and executed. Do you see a performance gain between >> disabling statement caching and enabling it, but setting the cache size >> relatively low? >> > > That's one of the things I'm hoping to find out. Sounds good. When you've played with it for a bit, tell us how things turned out. Good luck, - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkrcvhoACgkQ9CaO5/Lv0PAEZQCfSkIv2eVTjZiKNtIA4x4EF5Ah U1wAn05svLDn6hYk+u6iHIDDd6/ggmU9 =BmOv -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
