Hi all, I'm using <cache-type type="unlimited" capacity="3000"/> on all my entities in mapping.xml in an attempt to ensure that I'm caching everything. My thought was that if everything is in memory the database would never be accessed but I've been profiling the application and even written some debug-code in the mysql-jdbc-driver and I'm starting to think some stuff still gets through and it slows down the test-application very much.
The statements the jdbc-driver reports are executed are for example when I execute a rather ordinary query. SHOW VARIABLES SET autocommit=1 SET autocommit=1 SET autocommit=0 SET autocommit=0 null commit commit rollback rollback As you can see no actual data is fetched so the cache is working in that way but there still seems to be some calls for other reasons. As these calls repeats for every query to the cache I make (and there are lots in some sections for application-reasons) the performance is poor compared to what it could be. My profiler states that about 50% of the responstime is spent in the mysql-jdbc-driver so I'm wondering if this is a known problem or if it is a configuration-mistake from my side? Regards Mattias Bogeblad _______________________________________________________________ Mattias Bogeblad | PH: +46 31 799 01 16 | MOB: +46 702 80 05 05 SPRAWL SOLUTIONS AB FABRIKSGATAN 7 412 50 G�TEBORG FAX: +46 31 799 00 10 _______________________________________________________________
<<attachment: winmail.dat>>
