Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I am sure that my suggestions might not be accurate one or you tried them already, but I'd like to give a try. As you mentioned that DB connection is bottleneck, I'll go after that.</p> <p>After reading the question, I find that time taken by transaction is proportional to iteration number. So it looks that entities created in first iteration are being sent to hibernate in next iteration. </p> <p>For example, in 4th iteration, entities created in 1st,2nd and 3rd iterations are also being sent for update or being sent to hibernate somehow. </p> <p>That could be the reason for degradation of performance as iteration progresses. As number of records to be updated/inserted/selected increases with each iteration.</p> <p>I can think of following possibilities on top of my head -</p> <ol> <li><p>Hibernate session used in first iteration is being used till end. Due to this, entities created in first iteration are being updated in later iterations as well. I read that you tried closing entity managers etc. But still, please check the place where sesssion is ending. You can create a new session in each transaction or delete the entities created in session after each transaction.</p></li> <li><p>The list which filters records for each iteration is sending already processed records. That means the list should send records from 300 to 399 in 3rd iteration, but records from 0 to 399 are sent to transaction.</p></li> <li><p>If you're using HQL, try using named query. Last time when I used Hibernate (about 8 months back), I noticed that when HQL is used number of objects loaded by hibernate are much more than named query.</p></li> </ol> <p>Hibernate provides a way to print actual SQL query/parameters sent to DB. You can check actual query sent to DB. Link for this - <a href="https://stackoverflow.com/questions/1710476/print-query-string-in-hibernate-with-parameter-values">How to print a query string with parameter values when using Hibernate</a></p>
    singulars
    1. This table or related slice is empty.
    1. POEJB transactions slowing down in one thread
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USTaps
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThanks for your reply, I have to add that nothing is returned from inner transaction. I checked and old entities from previous iterations are garbage collected. After your reply I tried to explicitly clear/close session after transaction finish, it didn't change anything. I also printed hibernate SQL statements and it confirmed that only 3 inserts and 1 update are done. I guess this means I'll have to find some workaround for now or switch to JDBC as Sameer Mali suggested.
      singulars
      1. PO
      1. USMateusz Zając
    2. COI'd like to suggest a final try with custom queries in hibernate. These are executed inside DB. Please see http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/querysql.html#querysql-cud That should help you to continue using hibernate and not switch to JDBC for perticular scenarios.
      singulars
      1. PO
      1. USTaps
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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