NHiberate count query

Question

In the NHiberante, I have this statement

 (from p in Session.Query<MyObject>() select p).Count();

is this equal to this ?

select count(*) from MyObject

assume object name is same as table name .

If the table data is huge, do we have a way to improve performance ?

thanks

If the table is really large, one way to improve performance would be to cache results or store a running total somewhere. Not much you can do to improve a rowcount as it is. — dotjoe, May 04 '12 at 14:04

score 1 · Answer 1 · edited May 23 '17 at 12:11

1

You can better use:

(from p in Session.Query<MyObject>() select p).LongCount();

SQLite query is:

select cast(count(*) as BIGINT) as col_0_0_ from MyObject myobject0_

You can create DBMS specific optimized queries with:

Session.CreateSQLQuery("sql query");

Questions about count optimizations:

edited May 23 '17 at 12:11

Community

answered May 03 '12 at 19:04

Gerard

1 Answers1