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.
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.