Both PEAR DB/Cache and ADOdb database libraries support cacahed recordsets.
See the PEAR sources and http://php.weblogs.com/adodb
Nick Wilson <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> * On 14-01-02 at 19:58
> * Nathan Cassano said....
> > 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?
> Have a look at www.devshed.com I'm pretty sure there's a good article on
> caching there that you'd find usefull. (if not there is *definately* one
> on www.zend.com)
> - --
> Nick Wilson
> Tel: +45 3325 0688
> Fax: +45 3325 0677
> Web: www.explodingnet.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
> -----END PGP SIGNATURE-----
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]