MySQL Forums
Forum List  »  Performance

Slow result when hibernate sends count(*) statements
Posted by: Tim Mahy
Date: February 26, 2005 05:08AM


we develop using Hibernate. This ORM framework generates sql statements and our mysql server doesn't seem to handle it quite good :)

this is an example of a query that is launched :

select count(*) from tblPostReaction this inner join tblUser user on left outer join tblUserLevel userlevel2_ on inner join tblPost post on left outer join tblPostType posttype4_ on where 1=1 order by asc

tblPostReaction has 500.000 records
tblUser has 17.000 records
tblUserLevel has 20 records
tblPostType has 10 records
tblPost has 7000 records

the mysql doesn't seem to respond to this statement.......must I configure something special on the mysql server ?

Options: ReplyQuote

Written By
Slow result when hibernate sends count(*) statements
February 26, 2005 05:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.