SELECT « Performance « JPA Q&A





1. Hibernate tuning for high rate of inserts and selects per second    stackoverflow.com

We have a data acquisition application with two primary modules interfacing with DB (via Hibernate) - one for writing the collected data into DB and one for reading/presenting the collected data ...

2. optimizing large selects in hibernate/jpa with 2nd level cache    stackoverflow.com

I have a user object represented in JPA which has specific sub-types. Eg, think of User and then a subclass Admin, and another subclass Power User. Let's say I have 100k users. ...

4. performance tuning using select and join    forum.hibernate.org

I was reading about the performance tuning in hibernate and came across the following statment. select: Lazily load the referenced object or collection with a separate SQL SELECT statement. It is the default value join: Eagerly load the referenced object or collection using an outer join I know that in case of hibernte3, the lazy is true by default. That means ...

5. Performance problem with selects..    forum.hibernate.org

Hibernate version: 2.1.6 Mapping documents: Oracle 9.02 Hi we have big problem with performance in our project. We make HQL select from one method. This select find one row in rather big table. I've checked in Oracle trace log that this SQL statement (in the morning I will send how it looks) is very quick but time between startin execution of ...

6. General Performance (outer join vs n+1 selects problem)    forum.hibernate.org

I have an address class with 2 one to many relationships (points and rectangles). I need to eager fetch both the points and the rectangles belonging to an address when I load the address. I am wondering how to load say 1000 of these addresses without ending up with a N+1 selects problem. My understanding is that I can only use ...

7. performance issue when using hibernate for selection    forum.hibernate.org

The answer to my last question looks good i asked for using hibernate for only persistence and for selection some other mechanism one reply was to use hibernate for both purposes i m working on a struts based application i have 1000 records in my ORDERINFO table and each order has almost 10 line items, when i want to retrieve this ...

8. Performance of queries with many selection criteria    forum.hibernate.org

Hello, I have a question about the use of hibernate queries for a database intensive bioinformatics application. I am completely new to hibernate, so bear with me (I did look through the hibernate docs, though, and didn't see an answer to my question). I am facing a situation in which I have to query for several thousand genes from a database ...

9. Hibernate Performance for CRITERIA / SELECT Queries..    forum.hibernate.org

If you want to use SQL then use JDBC Selects. If you want to put some effort into using Hibernate to abstract away the SQL for relationships, then use hibernate. With hibernate you will replace the selects with calls to get inside of objects, but you will need to spend the time to map your database schema into hibernates XML files ...