[ 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
|
