Hi all,

Acutally looking at nHibernate but the forum is locked, same principles should apply though.

- We have optimised stored procedures in Oracle working on very very large data tables. From what I've seen hibernate generates SQL itself to fire at the DB. This appears to bypass the Oracle optimisation engine and thus may slow us down a fair bit. Is Hibernate a good solution when dealing with this sort of issues?

- Am I missing a trick here, do you load up data in a different way i.e. lots of it then filter it down? Probably not the best strategy if dealing with a million rows!

- Is Hibernate a good solution for huge databases?

Thanks, Tim