performance « Batch « JPA Q&A





1. Improving performance of Hibernate based batch program    coderanch.com

Perhaps. My guess though is its memory, extra processing load and probably poor SQL that are your bottlenecks . Have you done any timings for the various stages in the process? If your program waiting for the database or the database waiting for your program? One thing worth noting, Hibernate (like any ORM) is not a great fit for bulk operations ...

2. PERFORMANCE, BATCH SIZE, MASS INSERTION    forum.hibernate.org

3. Batch Processing Performance    forum.hibernate.org

Hi , In one of our applications we are trying to insert more than 2 million records into database. We have to use hibernate and our API to build the objects into database because of the complexity of logic involved in constructing those objects. Obviously we have to do batch processing because of the volume of inserts to not hit out ...

4. worry about the batch insert performance    forum.hibernate.org

hi erik, thanks for your kindly advice. In our production system, we might have 18 millions records need to be inserted for one operation. I am thiniking should I handle at this level( I mean at the DB access level), or should this be handled at higher level(application level), or maybe some asynchronous approaches need to be considered? I have no ...

5. replicate performance - seems to ignore batch-size    forum.hibernate.org

Subject says most - I found that when I do replicate(), hibernate is executing single queries against the database: select ID from TABLE where ID = $1 this is the exact query. This wouldn't be a problem except there is like 30k of these queries to perform. I have batch-size turned on at both class and bag/set levels, and nada. Am ...

6. Performance improvement with batch updates    forum.hibernate.org

We are having some real performance problems, due to the large number of records we need to process. One example is where we need to modify a large number (say 10,000) entity beans. Here is sample code using the entity manager: void moveDogs(List dogIds, Owner newOwner) { for (Integer dogId : dogIds) { Dog dog = em.find(Dog.class, dogId); dog.setOwner(newOwner); em.merge(dog); } ...

7. Batch Processing(Performance Issue)    forum.hibernate.org

Hi frndz, I am inserting batch of records. For a single request am inserting more than 200000 records. So am inserting on the basis of batch process. Here am inserting into three table at a time through relationship and also am inserting 13kb file into table. For 40,000 records it takes more than 1hr 45mins. Is it possible to decrease the ...