Hibernate HQL takes more time than Query in TOAD/Oracle Deve

adas · **Posted:** Wed Sep 11, 2013 1:21 am

Hi,

I have found performance low while setParmeter used to parametrized the HQL after the Query object is created. The complex query takes 2/3 sec in application but the same query in TOAD takes 0.6 sec.
When I formed the query string with all parameters were set, and the Query object was created finally. The time is reduced drastically.

Can you help me ?

The sample code as follows:

Quote:

1. set the parameter values.
2. Form the final query string
3. Get the Session object
4. Query query = session.getSession().createQuery(queryString);
5. List tempRes = query.list();

Regards,
Abhijit