ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Glenn Barnard <barnardgl...@gmail.com>
Subject Re: Prepared Statement cache
Date Tue, 21 Jul 2009 21:09:58 GMT
restart your webservers!

On Tue, Jul 21, 2009 at 5:00 PM, Michael Schall <mike.schall@gmail.com>wrote:

> We run are running iBATIS within WebSphere 6.1 on Windows using JNDI
> against a DB2 database.  During a performance tuning session we found a
> query using an index that did not have a vital column.  We added the missing
> column to the end of the index on a test database and using a db2 query
> analyzer we saw a big performance gain.  We moved the index to our
> production servers and see similar gains using db2 tools, however we do not
> see the benefit in the WebSphere application.  How/Where are are prepared
> statements cached and how can I clear them to get a plan that takes
> advantage of the new index.
> Thanks
> Mike

View raw message