Hi,

we develop using Hibernate.

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 ?

we thought of using the SQL_CALC_FOUND_ROWS feature of mysql to overcome this problem, any help on this idea would be appreciated :)