This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Why each hibernate3 query is making full tables scans?

Nirmal Vidura
Posts: 9
Hibernate jQuery Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic