Persistent Database Resources?

Lets say I have a page that makes queries with multiple sorts, returning plenty of rows and displaying part of the result set. Each time the client accesses the page the query must be re-executed, spinning the CPU and thus tieing up resources. In PHP, or any other language could the result set be stored persistently until the client accesses the page again, or the result expires and must be re-executed?