1. Performance issues with bulk delete operation forum.hibernate.org3.1rc2: DB2 V7: I have a simple scenario where I am performing a bulk delete operation via a DAO 500 times (for different business keys). Using an HQL bulk delete it takes 2000 times longer to execute the queries than using JDBC (146 seconds compared to 0.08 seconds). The HQL way looks like Code: public class AssetLifeHistoryDAO extends AbstractDAO { ... |
2. How to improve performance of bulk inserts/updates?? forum.hibernate.orgHi, I'm using hibernate's saveOrUpdate(myObject) method for insert/update operation. The "myObject" that i'm passing in the saveOrUpdate method contains 1 Set object that contains around 700 objects. Save operation on "myObject" takes around 20 minutes. I'm using batch insert/update with batch-size=20. 20 minutes is considerably a very large amount of time so i want to reduce the insertion/updation time. I've observed ... |
3. Performance Issue with Selects and Bulk inserts forum.hibernate.orgAre you selecting as you are inserting your bulk data? If so then your session is probably growing to a massive size and before the select is executing that auto flush is being triggered and the session has to see if anything is dirty which has a big negative impact on your selects. However, this is all guessing as you ignore ... |
4. performance issue with bulk update forum.hibernate.orgI'm doing some data processing using Hibernate. Following is the basic logic: 1. the data to be processed are read from a file in one shot 2. select pojos from database as data are being processing 3. basic on the data, the pojos may be updated or created 4. all the pojos are kept in memory and in the end, I ... |
5. Bulk Insert into Sybase - performance forum.hibernate.org |