Hi
I am doing pagination in hibernate. The query returns me a very large data result set after a search.
Here the page size is 20 records per page. I am using SQL server 2008.
My application is performing very slow
when getting navigating the result pages. I am confused about where the problem is....
Do opening a session like this and not closing it at the end is effecting performance.....
The above code will be executed each time the user clicks on next page or previous page buttons.
Thanks in advance for help.