To give a bit of background, lets say it's a generic results page, which is paginated so there are X results per page.
Generally to do this, I have two queries on the page:
- to get the total number of results
- to get the results, limiting by the correct page's resultset
However, recently I've been trying to cut down on the queries the site is making, and I thought one way to do this would be to only do the query if any parameters to the page have changed (except of course the page number)?
This would then cache all the result id's in a session, which can be sliced when I need to return the correct resultset for that page.
I was trying to look around the net to see if there are downsides of this method, but I've found very little information about it.
Has anyone done this before? Is it a good idea?