tag:blogger.com,1999:blog-8475025587762872101.post6427347013279201703..comments2022-04-01T21:34:55.987-07:00Comments on Tadaya's Blog: Hibernate: Single Shot Query to get Count and Data by ScrollableResultsttddyyhttp://www.blogger.com/profile/13171169321033441226noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8475025587762872101.post-21594107061332456942009-08-04T11:29:44.686-07:002009-08-04T11:29:44.686-07:00Hi
I tried to use you code on my Oracle10 and it ...Hi<br /><br />I tried to use you code on my Oracle10 and it does not seems to work...<br />I introduced a couple of modifications and now it works.<br /> ScrollableResults scrollableResults = q.scroll(ScrollMode.SCROLL_INSENSITIVE); <br /><br />scrollableResults.first(); <br />//since we are counting from 1<br />scrollableResults.scroll( scrollOffset -2);<br /><br />I just wanna to ask if you had any performance problems using ScrollableResults?<br />In my DB table i have 160K rows and using this approach it takes very, very long to retrieve each page.<br />If i do thread dump i can see it is stuck in scrollableResults.last() call.milushttps://www.blogger.com/profile/04255791953013506623noreply@blogger.com