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
– dotjoe, Commented May 4, 2012 at 14:04

Community · Accepted Answer · 2017-05-23 12:11:27Z

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:

CommunityBot

11 silver badge

answered May 3, 2012 at 19:04

Gerard

2,5112 gold badges26 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1