I want to run a query that returns 10 results per page. I know I can use "setFirstResult" and "setMaxResults" to get the items for the current page. But, I also want to display to the user "page x of y of z results". I know x is the current page. Y can be calculated if I knew Z. I can figure out Z by re-running my query using a the count feature. However, that means I have to run several queries to get the data to the end user. Is there any elegant way to handle this type of thing to prevent multiple calls to the DB?

If you can do it in SQL you can do it in HQL...

What would be the SQL way?

It depends if the list is updated frequenly or not. I dont know the best way to do it, but you can cache the result if it not too heavy, cache only the ids, or make a count one time and modify the HQL to navigate in the result list... (remember only the last id of the 10th element), or make a count each time and reajust the query, if the list can change each minute...

It depends of the kind of search engine you want.

Etienne.

I'm not sure what the correct SQL way would be actually. If I make this 2 queries then there's a chance the 2nd query will return more or less results than the 1st query.

Then make only one query to have the total of search result and the complete Ids of them, save it in a http session and browse them after.

I am not sure it is a "best practice", anyway. It seems to be a business problem not a hibernate one.