Performace issue with hibernate

techluver · **Joined:** Thu May 03, 2007 6:24 pm **Posts:** 14

Hello,

I'm using hibernate 3.2 JPA in my project. We are having performance issue. Not sure whether it is because of hibernate.

When I query the data using hibernate/jpa program, It takes 12-14 seconds for executing the query. If I do the same query in db direclty, It takes only 5-6 seconds.
What could be problem here and how can I rectify it? Please help me on this?

Thanks

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

Have you used JProfiler?

It's pretty good. It's got a trial license. You can use it to profile your application and find where things are taking a long time.

techluver · **Joined:** Thu May 03, 2007 6:24 pm **Posts:** 14

Hi,
Thanks for your reply.

In this issue, we know the hibernate query is taking longer time than direct SQL query . This issue happens only when there is huge amount of data in DB. I think I need to do some optimization. Please let me know what kind of optimization I should do in hibernate for less response time.

Sagi · **Posted:** Tue May 15, 2007 2:55 am

use indexing in your database...