Dear All,
i'm using HIBERNATE 3.1 deploied in JBOSS 4.0.2 and PROGRESS 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 suggest to me why and any solution?

Thanks in advance,
Davide