wood burning stoves 2.0*
The moose likes Performance and the fly likes Hibernate: Performance issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "Hibernate: Performance issue" Watch "Hibernate: Performance issue" New topic
Author

Hibernate: Performance issue

amit attri
Greenhorn

Joined: Aug 24, 2011
Posts: 8
I'm working on a java servlet application that uses hibernate with oracle.
This issue concerns with hibernate transaction (between session.beginTransaction() and commit).

I'm running a 30 transaction per second load in which all transactions are updating a single column of a specific row of table.
Say, column is C, Row is R and table is T.
The time taken to run this update command is very high via hibernate.

I did an experiment, in which I used pure jdbc instead of Hibernate and results were awesome.

So first question is that, Can I make a pure jdbc hit using hibernate ?
(I tested with Hibernate 3.2 native SQL API (createSQLQuery) but results were pretty bad)

If yes, Can I use hibernate query as well as pure jdbc hit in a single session of Hibernate.

--------------------------------
Example:

objTransactionManager = session.beginTransaction();
session.update(TransactionCountDTO); --> This is a hibernate object
session.save(MoneyTransactionDTO); --> This is a hibernate object
session.executeUpdate(sqlQuery); --> This is a pure jdbc hit
objTransactionManager.commit();
-------------------------------

Please help. I'm stuck in a mess here.
 
 
subject: Hibernate: Performance issue