NHibernate vs Stored Procedures

V

Velese2013-10-03 17:11:53

Oracle

Velese, 2013-10-03 17:11:53

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?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

DenKrep, 2013-10-03
@Velese

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).

B

Bick, 2013-10-03
@Bick

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