[nhibernate-issues] [JIRA] Closed: (NH-461) Slow paging in sql server

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-461?page=all ]
     
Sergey Koshcheyev closed NH-461:
--------------------------------

    Resolution: Won't Fix

Won't fix it now that SQL Server 2005 has satisfactory support for paging.

> Slow paging in sql server
> -------------------------
>
>          Key: NH-461
>          URL: http://jira.nhibernate.org/browse/NH-461
>      Project: NHibernate
>         Type: Improvement
>   Components: Core
>     Versions: 1.0
>     Reporter: Ron Liu

>
> For example, I have 5000 records in a table. When I retrives the first 100 rows, the speed is ok, but it getting slower and slower when I try to retrives the next and next 100 rows. I monitored the sql server, the generated sql is like "select top 100" for the 1st, but "select top 200" for the 2nd, ...
> I think it can be improved by created a temp table or a table varible which just store all the ids at first, and then render back by join that temp table. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira