Re: Persistent Database Resources?

Hi, Both PEAR DB/Cache and ADOdb database libraries support cacahed recordsets. See the PEAR sources and http://php.weblogs.com/adodb Rgds, John Nick Wilson <nick@explodingnet.com> wrote in message news:20020114190101.GB1350@explodingnet.com... > -----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 > > iD8DBQE8QyrtHpvrrTa6L5oRAk2FAJ40NBy2f4nOWWQ2341qhu2FlcrXVwCffzmg > V9IXgNa9QnnCarHSHzjn+pw= > =24yn > -----END PGP SIGNATURE-----