Databases
StackOverflow2013
Postsdbo
POHow to track result set size using hibernate?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to track result set size using hibernate?
    text
    copied!<p>I'm trying to detect and optimize inefficient joins within a Java/Hibernate application. I've noticed that in some cases, due to the nature of how joins are handled in result sets, the over-the-wire data flow is very inefficient. </p> <p>Let me provide an example. Suppose you have an HQL query that looks like this:</p> <pre><code>select s from Store s left join fetch s.items i left join fetch s.employees e left join fetch s.customers c where s.id = :id </code></pre> <p>(Ignore for a moment that this is not a smart query - it's just a simplified example).</p> <p>If you imagine that a given store has 1000 items and 10 employees and 100 customers, you will get back a java object tree with 1111 entities. That might lull you into thinking that approximately 1111 rows were returned from the database, whereas in fact the result set had 1,000,000 rows!</p> <p>The presence of all the columns makes this worse. If you imagine that each table had 5 columns, you might imagine that you got approximately 5555 "items" back, whereas the number of cells (row * column) in the result set was actually 20,000,000.</p> <p>Clearly, it is the application developer's responsibility to be aware of this issue and not write queries in that way. However, this sometimes happens unintentionally (and in less severe ways), and it would be great to be able to instrument the application to somehow identify these situations.</p> <p>However, I've been unable to find any way to calculate (from within a Java/Hibernate app) either the number of rows or the number of columns in the raw result set. Neither Hibernate interceptors, Hibernate events, nor Hibernate statistics seem to give access to this information.</p> <p>Any suggestions? Thanks in advance.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload