Slow result when hibernate sends count(*) statements

[Tim Mahy]

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 ?