performance hibernate

soussou · **Joined:** Tue Nov 16, 2004 9:43 am **Posts:** 11

Hi;

I would like to use Hibernate for my web application, with the following contraints :

1- I have already 50% of the SQL requestes (complex select) which are implemented
2- My application is used for only consulting of the data (nothing update in to database, but only of the select).
3- My application will be used a significant number users and a big database.

So its useful to use Hibernate for that ?

Regards;

anthony · **Posted:** Tue Nov 16, 2004 10:34 am

if you have real domain model yes,
if you only "try" to map a legacy db to some kind of class diagram, i don't think so

christian · **Posted:** Tue Nov 16, 2004 10:36 am

Use Hibernate, you can put your SQL queries in your Hibernate metadata (as named queries) and you can use read-only queries (projection, dynamic instantiation). It also sounds like you can make good use of caching.

anthony · **Posted:** Tue Nov 16, 2004 10:45 am

if the legacy db has been designed with "anti" patterns, associations will be limited and even with SQLQueries, it will be hard to maintain, no?

soussou · **Joined:** Tue Nov 16, 2004 9:43 am **Posts:** 11

christian wrote:

Use Hibernate, you can put your SQL queries in your Hibernate metadata (as named queries) and you can use read-only queries (projection, dynamic instantiation). It also sounds like you can make good use of caching.

OK.

For the moment, I have a correct MCD avec of the SQL vues and functions for the select (for my requestes, I not use directlty the database but of the vues). This model has been realized in delphi environnement.
Today I must realized a j2ee web application which access to this database and display some informations (read only : consult).
I use struts (for GUI) and spring component (services) and I would like to use Hibernate and if possible all my SQL vues and functions already implemeted.

My question : its a good thing or not ? Which are the performance of the Hibernate in these cases (JDBC traditional solution) ?

regards;

christian · **Posted:** Tue Nov 16, 2004 12:10 pm

It's impossible to summarize this in two sentences. Please consult the "Performance FAQ" in the documentation area of the Hibernate website. If you need more basics, consider buying Hibernate in Action.

soussou · **Joined:** Tue Nov 16, 2004 9:43 am **Posts:** 11

christian wrote:

It's impossible to summarize this in two sentences. Please consult the "Performance FAQ" in the documentation area of the Hibernate website. If you need more basics, consider buying Hibernate in Action.

Hi Christian;

My question do not relate to the hibernate performance.
I would like to know the opinions of people who used Hibernate in their project.
I have explained my problem with these constraints and I try to find a good solution with a help of the Hibernate experts.

christian · **Posted:** Wed Nov 17, 2004 5:17 am

You ask about "performance" and then you say your question is not related to performance?