Re: Mysql and Tomcat 5.5 strange performance
Doug,
Are you using InnoDB tables? Do you keep an 'open' transaction on the 'refresh' page (i.e. no commit/rollback)? If so, since InnoDB runs by default in REPEATABLE_READ isolation level, you'll _never_ see the updates done by other threads/connections from your 'refresh' page until you commit/rollback _after_ the other transactions complete.
The JDBC driver itself does no caching behind scenes, it only delivers what's in the database itself.
Subject
Written By
Posted
December 20, 2004 02:26PM
Re: Mysql and Tomcat 5.5 strange performance
December 20, 2004 10:11PM
December 21, 2004 07:57AM
December 21, 2004 09:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.