hql « Performance « JPA Q&A

  1. JPA Q&A
  2. Performance
  3. hql




1. HQL Performance Issue    forum.hibernate.org

Hi, Im using HQL to perform a query, this HQL Query takes approximately 500 ms to execute in a single thread, but with 20 threads it takes more than 10000 ms. It seems that for each concurrent thread there is an increase of 30% in processing time. This is not a connection pool issue because I have already checked that (the ...

2. HQL performance    forum.hibernate.org

All yo hibernate Gurus, Hi , I am lookinng into some performance tuning of a query .The scenario is i retrieve some ids iterating over a list and pass them to a query as parameter so there are as many queries as iterations .Can i have a list directly passed to a query as a parameter and return the List at ...

3. Performance goes down when HQL contains aggregate.    forum.hibernate.org

Hibernate version:3.0.2 Mapping documents: Code between sessionFactory.openSession() and session.close(): List result; ModelGroupViewI row; String queryStr = "from ModelGroupView ca group by ca.id order by ca.id asc"; HibernateUtil.beginTransaction(); Session session = HibernateUtil.getSession(); try { result = session.createQuery(queryStr).list(); } catch (HibernateException ex) ...

4. HQL Performance    forum.hibernate.org

Is there a difference in performance of HQL if you select individual columns vs selecting a whole object? When I use HQL to select a whole object the query takes about 7 min to run (table has about 5k records in it). If I explicitly define the columns the query runs in about 5 seconds. HQL that takes 7min Code: getHibernateTemplate().find( ...