0

my project has a lot of time restrictions on access to functionality. Layer view, I have a very fast, but I have a problem with DAO layer. Currently my DAO layer uses hibernate. But I noticed that I had with him a lot of problems and I can not modify it so that any optimization mechanisms use to database.

In my database there are about 20 million users in relation to the tables where there are thousands of tuples. Tables are partitioned for faster access.

I wonder what framework to use instead of hibernate. I thought about using iBatis. I want to know about you think about this idea? Is iBatis will allow me to tune queries / updates in order to make efficient use of such a large database? Can I full use partitioned database?

Can you recommend any other solutions?

BD: Oracle.

Thanks for any help.

tomasz-mer
  • 3,753
  • 10
  • 50
  • 69

2 Answers2

0

You should be able to improve Hibernate performance or query performance in Hibernate. Could you elaborate more on where your problems and restrictions are? Could you post some code?

Thomas
  • 87,414
  • 12
  • 119
  • 157
  • Hibernate generates SQL commands alone. I have no influence on their shape. I can not add, for example, tips or hint for tuning. – tomasz-mer Apr 13 '11 at 08:22
  • Actually, you can provide several hints for hibernate, have influence on the HQL queries and on the entities and their annotations/configuration. Using that you can optimize Hibernate to a high degree, but you'd first have to understand why Hibernates creates a certain query in a certain way. – Thomas Apr 13 '11 at 08:27
  • You could also use plain SQL with Hibernate, although that would be kind of counter the main purpose of Hibernate. – Thomas Apr 13 '11 at 08:28
0

use Ibatis, you could do query optimizing much much better than in hibernate, and the most important is separation of sql queries from the DAO Codes.

pekoy
  • 16
  • I was read this article http://stackoverflow.com/questions/716532/hibernate-ibatis-jee-or-other-java-orm-tool it's great! – tomasz-mer Apr 13 '11 at 11:35