database « Performance « JPA Q&A

1. What is the fastest findByName query with hibernate?    stackoverflow.com

I am sure I can improve the performance of the following findByName query of hibernate:

public List<User> findByName(String name) {
  session.createCriteria(User.class).add(Restrictions.eq("name", name)).list();
}

2. Hibernate performance issues using huge databases    coderanch.com

Hibernate sucks. Its performance is so damn slow when accessing, migrating large databases. We just tested our application on the actual database only to find that it is taking anywhere between 20-30 minutes to just run a simple query such as a join on a couple of tables with each table having about 100,000 records. Its too late and we are ...

3. Low performance because of unneccesary database roundtrips    forum.hibernate.org

Hello, I have a question regarding Hibernate performance of the "where in" clause. for example: Quote: select * from document where doc_id in (10, 11, 12) Hibernate seems to insist on running this as follows, resulting in several unneccesary database roundtrips and dismal performance: Quote: select * from document where doc_id = 10 select * from document where doc_id = 11 ...

4. Performance Problem on database view in MSSQL    forum.hibernate.org

I'm having a serious performance problem when querying against a view in MS SQL. The view (10 columns) joins 7 very small lookup tables with a large (200k rows) fact table. All queries (returning from 1 to all rows) I execute against the view run very quick. Yet, when I use hibernate it's very slow. I created a table with all ...

5. performance issue because of Deeply Nested DB structure    forum.hibernate.org

6. Improving performance using Hibernate with a legacy database    forum.hibernate.org

Hello All, You will probably tell me to CTFI on this one, but I have been searching for a little over an hour and can find no best practices, standard solutions, or examples regarding my problem. I am using Hibernate with a legacy database system and I have no control over the database structure. I have Hibernate configured properly and running ...

7. Performance issues in hibernate with large database    forum.hibernate.org

Hi......... What are the performance issue if i use hibernate in place of jdbc(DAO Pattern) in a database that has a large no of tables ,and tables having large no of columns(between 200-300). actually we are considering to use hibernate for a banking solution? So the main thing is that HW CAN RETRIEVE LIMITED COLUMN OF TABLE WITHOUT CREATING A NEW ...

8. Hibernate and Teradata database performance issue    forum.hibernate.org

Hi, We are using Hibernate and Teradata database as the backend in our application and facing high performace issue during joining with multiple tables. I am not using native sql concept but using Category for the retrieval. Have anybody realised the same problem earlier with Teradabase? What is the Hibernate compatibility with the Teradata database? Please provide some inputs.. Thanks,..

9. Identifying DB performance problems    forum.hibernate.org

I've been working on an application that exhibits inconsistent performance under load. There is a suspicion that the database is causing some of the performance problems, however I need to categorically prove that. Is there a way that I can get hibernate to identify exactly how much time is taken for each SQL statement that it executes on the database? Obviously ...