table « Performance « JPA Q&A





1. Hibernate multiple table join, performance keep    stackoverflow.com

Possible Duplicate:
What is the n+1 selects problem?
how to keep the performance about the hibernate multiple table join? To avoid the N+1 sql query?

2. table with 5-700 cols, performance issue?    forum.hibernate.org

We've got a table with 5-700 cols. This table is in 3nd normal form as far as I can tell. We could break chucks of cols off to seporate tables but they would have 1:1 relationships with "mother" :-). Would this be preferable to 1 table with 5-700 cols? My opining is that separate tables would be much preferable. But this ...

3. subquery+large table=performance hit???    forum.hibernate.org

I have three persistent objects, user, site, and health. A user may have multiple sites. A site is monitored by a health check and the health status is recorded in HEALTH table (health). My mapping is as follows, User.hbm.xml: ... ... Site.hbm.xml: ...

4. Performance and Scalability: 100 Tables and 250 Users    forum.hibernate.org

Hi: I am in the process of evaluating the use of Hibernate for a call center application that would have close to 250 concurrent users doing mainly select operations (quering information) on close to 100 tables. The expected no. of records in the db is likely to be 100 Million. We have decided to use Struts for the Presentation layer of ...

5. Performance & Scalability: 100 Tables & 250 Users    forum.hibernate.org

Hi: I am in the process of evaluating the use of Hibernate for a call center application that would have close to 250 concurrent users doing mainly select operations (quering information) on close to 100 tables. The expected no. of records in the db is likely to be 100 Million. We have decided to use Struts for the Presentation layer of ...

6. [performance] Remove all entries in a table?    forum.hibernate.org

7. Performance Problems with Hibnerate on large table.    forum.hibernate.org

jdbc/MDIDB com.ibm.websphere.naming.WsnInitialContextFactory net.sf.hibernate.dialect.DB2Dialect true true 10 ...

8. Full table access - performance issue    forum.hibernate.org

Hibernate version: 2.1.8 Hi everybody! Here is the problem: I have 5 tables and 5 classes: X, Y, I, G. They are mapped with "one-to-many" as following: X --one-to-many--> Y I --one-to-many--> Y I --one-to-many--> G As you can see, there are 2 classes which are pointing to class Y. In my program, i am loading class Y. Loading of this ...

9. Hibernate performance with simple table    forum.hibernate.org

Hi. I am building a query that contains a LIKE cause via the Criteria api. The query runs quickly (1 or 2 seconds) in SqlDeveloper. The same query takes 8-9 seconds when I run a test case with Hibernate. After I turn on debug, I see the pojo instances getting loaded, and then I get a bunch of TwoPhaseLoad messages indicating ...