Dear All,
i'm using HIBERNATE 3.0 deploied in JBOSS 4.0.2 and PAGRESS DB.

When i want to execute this query:
Criteria query = session.createCriteria(persistentClass);
query.setFirstResult(pageSize * pageNum);
query.setMaxResults(pageSize);

with pageNum (page Number) >0 the respose takes seconds (near a minute!), instead when i ask for the page 0 the result is returned very quickly.

Can you suugest to me why and any solution?

Thanks in advance,
Davide

Get the actual sql query (turn on the log) - and execute it against db.

Since this is what is probably slow - there is no known overhead with Hibernate regarding this.

And then try to write more optimal query - if it is possible.

Rgds, Ales