NHibernate vs Stored Procedures

Question

Oracle

It is necessary to implement data sampling from the Oracle database. There are 2 tables containing several million records. Selection of all portions and search by id. Is it possible to work with Nhibernate with such volumes of data? What will be the speed of work? Wouldn't it be better to use stored procedures?

Answer 1

Why don't you just want to do a SQL select that will return the rows that match your condition? 99% sure it will work faster. Well, or through a stored procedure (although from the description of your condition, I didn’t understand why you need a store. To select rows from tables by condition, ordinary SQL will be enough).

Answer 2

My advice to you - as in all such cases, use the database profiler.
See what queries NHibernate generates. Compare. Decide.