Nhibernate fetch

I fetch all data from table by hql query like"from table"(this query return only one column) Size of table 79000000(79 M) rows I limit size of answer by SetFirstResult(0) SetFetchSize(2000). It doesn't help . NHibernate throw OutOfMemory Exception.

I use Ora开发者_如何学Gocle. Thx

---

If you want to limit the resultset to 2000 you should use SetMaxResults(2000).