Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

3.1


Hello everyone,

I have the following to work with but I don't know the answer to this and if it should deal with Hibernate. I am a hibernate beginner.

Currently, I have objects that are pulled from the database with Hibernate.
However, I have a set of complex queries that will be run on different sets of records within a specific table. THese queries will pull statistics about sets of records in a table. How do I model this in Hibernate and what is the most efficient way of accessing these complex statistics in real-time? I have a critical web application that I am now working on that requires these statistics to be accurate.

Any help is very much appreciated,

Alex

I think you need to be a bit more specific....
In terms of queries HQL
can do a lot for you.... like work aggregate functions etc....

Hi everyone,

Basically I have a Java object where none of the object properties corresponds to a table field. Each object property is the result of a complex query. There are about 15 complex queries that need to be done to create the object and my concern is in efficiency. Will it take too long to create the object? Does my java Object needs a Hibernate object mapped? Is that possible and/or necessary? Or should I just use HQL to create the object? Or create a view in SQL Server? If anyone knows of an efficient way to set this up on SQL Server 2000, I would greatly appreciate advice.

Thanks! Obrigado!

Claudio

Hi,

To go towards Complex queries and retrieve values its better to go for View.

you wrote
create a view in SQL Server


Views are faster.