result « Performance « JPA Q&A

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




1. Hibernate dynamic query performance issue solutions using result transformer!    stackoverflow.com

This is a important addition especially to solve performance issues while being able to write efficient dynamic HQL queries. But, how do we modify the HQL transformer in case of loading ...

2. How to cache queries in EJB and return result efficient (performance POV)    stackoverflow.com

I use JBoss EJB 3.0 implementation (JBoss 4.2.3 server) At the beginning I created native query all the time using construction like 

Query query = entityManager.createNativeQuery("select * from _table_");
Of couse it is not ...

3. Scrollable result sets and performance    forum.hibernate.org

Hello, After doing some general (Oracle) jdbc performance tests I noticed that the ResultSet.absolute() and ResultSet.relative are slow for large (50000 records) sets. For example, to access record 50000 takes about 1437 ms, while record 50 takes 15 ms. This is particularly relevant for large lists and paging. There also seems to be a much higher memory usage when using absolute() ...

4. How to optimize performance on large result sets?    forum.hibernate.org

Hi, Here is my situation. I have a class called Order. This has a many-to-one relationship with Customer, has a one-to-many relationship with OrderItem, which has lazy="true". I need to generate a report of Order objects using a certain selection criteria, such as orderDate > mm/dd/yyyy. I use a namedQuery to achieve this. The query returns a large number of results ...