query and page loading optimization

[CybJunior]

Hi
Is there any way to keep the results of a query in some cache or other file. I have a pagination script and every time you go to the next page the query executes once again and that makes it load too slow. Can you help me some info or links to where it is described.
Thanks

[devinemke]

sessions

[CybJunior]

Thanks, but what exactly should i use to store the query results and then take them from the storage?
Another question is that there is only one page where the queries are and i when i press page2 for example it refreshes itself with page=2. Does it mean that all queries will run one more time? If it is so, how should i restrict them from being executed if the result is already stored in cache or elsewhere?

[devinemke]

if all you are doing is pagination then you need to code your queries to only grab the rows needed for that page. using the LIMIT clause in your queries you can control which records are fetched. this is a better method then grabbing everything on each page request.