hi every one,
i am using nhibernate 2.1.2 and sql server 2008, i am getting problem
with paging
generated query:
SELECT TOP 300 y0_, y1_, FROM (SELECT distinct this_.id as y0_,
this_.candidate_name as y1_,ROW_NUMBER() OVER(ORDER BY this_.id DESC) as
__hibernate_sort_row FROM candidates ) as query WHERE
query.__hibernate_sort_row > 300 ORDER BY query.__hibernate_sort_row
problem statement:
if i click next page the above query fetching all 10000 thousand records
and applaying filter to that. because of this performance is reduced.
suggest any idea to in different way.
thanks in advance
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/9jzUUDeEwdwJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
