Hi Everybody,

I am in need of your great help.Actually I have to take a decision among hibernate with stored procs vs hibernate with entiy classes and tables.

My requirement here is to achive peformance.

Which way among these two ways provides good performance? and how can I prove that programatically?


It would be great, if u guide me.


Thanks,
Ramakrishna

Be aware that performance bottlenecks can occur in several places; it’s always a good idea to consider that Stored procs are part of the application code that has been moved to the DB server. Having a lot of StoredProcs can make your data access layer look lighter but you could create a performance bottleneck in the DB server, which can be more difficult and expensive to scale as opposed to scaling an application server.

Remember the DB server in most cases are shared, if your StoredProcs cause problems; it may affect other apps. In short, if you have a lot of SPs and you end up having the db server underperforming, you may need DBA help, but if you have no SPs and your data layer underperforms, you have only one place to look for problems (the code), you can use profiling tools to identify problems, and take appropriate actions, like throw in a new box, cheaper that a new SQLServer box and license.