Problem HIbernate + Mysql

Question

I'm having the following problem. I have a survey which indicate the start / end of a given process. When I select the start date, everything works. When I put only the end date (and no other filter the search), here comes the problem.

I have a monster delay in the research and the session falls Ext. My bank has about 250,000 registered data to date. I did the following test:

Selected dates relating to the first cases registered and operated properly. Is there any way to improve this search?

Detail: I ran the query that generates the hibernate and research was done in 26seg.

Here's an excerpt from my method:

1. DetachedCriteria criteria = DetachedCriteria.forClass(tipo);
2. criteria.createAlias("sinistro", "sinistro");
3. criteria.createAlias("responsavel", "responsavel");

I insert the data from the properties ... and

1. try {
2. setOrder(criteria);
3. List retorno = null;
4. 1. DetachedCriteria rowCountCriteria = (DetachedCriteria)SerializationHelper.clone(criteria);
5. 1. int firstResult = 0;
6. int maximumResults = 0;
7. 1. if (maxResults != null)
   2. maximumResults = maxResults;
   3. 1. if (pageNumber != null)
   4. firstResult = (pageNumber * maxResults);
   5. 1. criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
   6. retorno = getHibernateTemplate().findByCriteria(criteria, firstResult, maximumResults);
   7. 1. rowCountCriteria.setProjection(Projections.rowCount());
   8. List results = getHibernateTemplate().findByCriteria(rowCountCriteria);
   9. if (results == null || results.isEmpty())
   10. rowCount = 0;
   11. else
   12. rowCount = results.get(0);
   13. 1. return retorno;
   14. 1. } catch (Exception e) {
   15. logger.error("Error:", e);
   16. throw new PersistenciaException();
   17. }
   18. }

Paging is being made. Frankly, I find no justification for the delay.

Thank you for your attention!