hi All,

We're just starting to use nhibernate and are loving it so far. One thing we noticed though is that for slicedfindall you basically have to do 2 separate queries. One to return the slice of data and a second to get the total count of the entire dataset.

Now a lot of databases such as mysql, oracle etc. support returning the total number of rows when doing a slice so you don't have to do another query to get back the total count of records. For our startup we're looking at browsing through 100000s of photos, videos, stats etc. and an optimization where, as part of the select that returns the slice, we also get back the total count would halve the number of queries we're running.

In Mysql there is a column returned as part of a query called SQL_CALC_FOUND_ROWS. Is there any way of accessing that column as part of the slicedfindall? I've looked in quite a few places but haven't found any reference to accessing this in nhibernate or even if it's possible. SQL Server and Oracle have their version of this as well and paging is such a basic thing that such an optimization would make a huge performance difference.

ed

Oren Eini has posted a way to do this on his blog. I've never used MySql but I'd say you could adapt the technique.

http://www.ayende.com/Blog/archive/2007 ... y-way.aspx

Wicked!! Thanks for the info....