[JBoss-user] [Performance Tuning] - Re: Strange behavior: slow JDBC queries
[EMAIL PROTECTED] wrote : How did you fix it? Now I found that: In MySQL 4.0, the query cache works only with autocommit enabled. This restriction is removed in MySQL 4.1.1 and up. And this is our problem. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3874865#3874865 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3874865 --- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Performance Tuning] - Re: Strange behavior: slow JDBC queries
[EMAIL PROTECTED] wrote : How did you fix it? It wasn't JBoss problem. After switch to MySQL master/slave the result sets of some queries wasn't sent to client but write to the tmp area of MySQL. We increase only the value of 'tmp_table_size' and we get better performance. Regards, Rafal View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3874410#3874410 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3874410 --- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Performance Tuning] - Re: Strange behavior: slow JDBC queries
fixed! View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3874375#3874375 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3874375 --- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Performance Tuning] - Re: Strange behavior: slow JDBC queries
How did you fix it? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=3874392#3874392 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=3874392 --- This SF.Net email is sponsored by: New Crystal Reports XI. Version 11 adds new functionality designed to reduce time involved in creating, integrating, and deploying reporting solutions. Free runtime info, new features, or free trial, at: http://www.businessobjects.com/devxi/728 ___ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user