jdbc « Performance « JPA Q&A





1. JPA/ORM vs JDBC for performance limited machines    stackoverflow.com

We are creating a small application that will be deployed to very limited machines. They have only 256mb of RAM. I would like to use JPA as it simplifies the code and ...

2. Avoiding JDBC call    stackoverflow.com

The scenario is like this:

for loop // runs say 200000 times
{
    // here, i do a select from a database, fetching few rows which are expected to increase ...

3. Hibernate: Performance issue vs JDBC    coderanch.com

Well, remember that all calls to Hibernate get translated to JDBC before they go to the database. Hibernate and JDBC are tied pretty closely together. Having said that, there are always optimizations that people that know SQL well can do to make their database queries hum. Hibernate doesn't invalidate the JDBC Java packages, so you can always call JDBC code alongside ...

4. JPA and JDBC, Which one is Performance efficient    coderanch.com

Hi I am working on an application that needs to be highly performance efficient. We will be having heavy data stored in data bases. And will be having hundreds of requests per minute and for each request will interact with database. Now JPA ease us from writing SQL and many more, but in this sceneraio, will JPA be that efficient as ...

5. Hibernate Performance compared to JDBC    forum.hibernate.org

Hi, I have written two sample programs one with hibernate and another JDBC. The program just looks up at a table and does a range scan and gets only 5 records out of 100,000. I am doing this 1 million times inside a loop. To my surprise hibernate takes more than 3 times that of JDBC. Can anybody let me know ...

6. "Read only" performance compared to JDBC    forum.hibernate.org

I am running a test with Hibernate and direct JDBC to read data from one table. I am using DB2 and Hibernate (2.0.3 and 2.1b6). I am running the test in a loop and reading all the data in one table (1000 records). The persistent Object contains only 3 (String) attributes. I used test class similar to net.sf.hibernate.test.PerformanceTest. JDBC is 2.2 ...

7. Performance comparison with JDBC    forum.hibernate.org

I'm doing a performance evaluation of Hibernate w.r.t JDBC and I find that in many cases Hibernate is a lot slower than JDBC - the Hibernate web site claims that the overhead is in the region of 10%. When I do very simple queries on an object that maps to a table - no joins involved and nothing fancy I find ...

8. Huge performance hit compared to raw jdbc    forum.hibernate.org

Hi all, We studied many frameworks for the database layer of our architecture and choosed hibernate. The application is a really large, clustered e-commerce system that must cope with HUGE amounts of traffic. To make things even worse, the traffic comes in bursts at certain times. So one of our main points why we decided to go with hibernate was that ...

9. Bad performance on query compared to JDBC    forum.hibernate.org





10. Performance weirdness compared to raw JDBC    forum.hibernate.org

Newbie Joined: Tue Apr 18, 2006 3:13 pm Posts: 8 I am trying to get some general idea of the performance of hibernate relative to straight JDBC and I am getting some very strange results and have consulted various documents on the hibernate.org site that haven't revealed my problem (forgive me if I have missed any). My initial problem was that ...

11. Hibernate vs JDBC. Performance    forum.hibernate.org

Author Message unkis Post subject: Hibernate vs JDBC. Performance Posted: Thu Jun 07, 2007 11:50 am Newbie Joined: Wed May 30, 2007 6:47 am Posts: 5 Greetings , at me such problem, I have noticed, that at use Hibernate, data are saved many times more slowly than at use JDBC. I have written an example, which puts in three ...

12. JDBC and Hibernate performance    forum.hibernate.org

Hi Gavin, Christian i am a newbie in hibernate, i am facing performance issue after implementing hibernate. i read your replies for one of the old thread and followed the hql queries that you suggested with improvement in performance but not faster than jdbc. jdbc still seems to be 4-7 times faster than hibernate, i am sure , i have not ...