I have a situation where I have to display results in the form of
page. To go about implementing I though of two things.
1) I keep the query as per the selection made by user in session and
limit the result every time user asks for a different page.This means
every time hitting the Db.
2)I get the complete result in a session variable eg: array of model
instances and then use index of arrays to paginate the result.This
will involve lot of memory usage.
I'll appreciate if someone guides me how to go about this.Displaying
result in pages is not an issue but the the way to achieve it has put
me on the back foot.
Gaurav V Bagga