MySQL Forums
Forum List  »  Performance

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

Hi,

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 this.userId=user.id left outer join tblUserLevel userlevel2_ on user.userLevelId=userlevel2_.id inner join tblPost post on this.postId=post.id left outer join tblPostType posttype4_ on post.postTypeId=posttype4_.id where 1=1 order by this.id 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


Subject
Views
Written By
Posted
Slow result when hibernate sends count(*) statements
3986
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.