I have recently deployed a struts-hibernate application to my server. However mysql runtime information says that "Handler_read_rnd_next" variable is too much than what it should be. Therefore I decided to enable MySQL query logging to find out what queries make full table scans. Found hibernate is running following statement before executing each and every SQL statement.
What is this query? Why hibernate is running this before executing each and every statement? Which config parameter can control executing this query?
following is my hibernate configuration file
Anything is simple when you know how to do it.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Why each hibernate3 query is making full tables scans?