aspose file tools*
The moose likes Object Relational Mapping and the fly likes Why each hibernate3 query is making full tables scans? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Why each hibernate3 query is making full tables scans?" Watch "Why each hibernate3 query is making full tables scans?" New topic
Author

Why each hibernate3 query is making full tables scans?

Nirmal Vidura
Greenhorn

Joined: May 24, 2006
Posts: 9

Hi,

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




Thanks.

Anything is simple when you know how to do it.
http://www.esrilankans.com/welcome.do
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Why each hibernate3 query is making full tables scans?
 
Similar Threads
Hibernate and MySQL connection issues
c3p0 configuration
Programatic Schema Export with Hibernate and EJB3
Perf Tests failing badly on mysql
c3p0 pool size exceeds maxpoolsize