Re: [GENERAL] Query meltdown: caching results

2008-02-27 Thread Norman Peelman
Gordon wrote: (Sorry for the repost but I thought this would be appropriate to both groups. I did tell Google to delete my first post but odds are some guys got that copy already anyway) After a lot of hairpulling, I finally found a mechanism in PHP for doing what I wanted. I just had to know 2

Re: [GENERAL] Query meltdown: caching results

2008-02-27 Thread Gordon
(Sorry for the repost but I thought this would be appropriate to both groups. I did tell Google to delete my first post but odds are some guys got that copy already anyway) After a lot of hairpulling, I finally found a mechanism in PHP for doing what I wanted. I just had to know 2 things: 1) How

Re: [GENERAL] Query meltdown: caching results

2008-02-27 Thread Gordon
On Feb 27, 10:37 am, Gordon <[EMAIL PROTECTED]> wrote: > On Feb 26, 5:26 pm, [EMAIL PROTECTED] (Gregory Stark) wrote: > > > > > "Norman Peelman" <[EMAIL PROTECTED]> writes: > > >> My options are, as far as I can tell, > > > >> 1) replace the Database PDO extending class with something else that > >

Re: [GENERAL] Query meltdown: caching results

2008-02-27 Thread paul rivers
Gordon wrote: On Feb 26, 5:26 pm, [EMAIL PROTECTED] (Gregory Stark) wrote: "Norman Peelman" <[EMAIL PROTECTED]> writes: My options are, as far as I can tell, 1) replace the Database PDO extending class with something else that provides query results caching in PHP, or 2) get P

Re: [GENERAL] Query meltdown: caching results

2008-02-27 Thread Gordon
On Feb 26, 5:26 pm, [EMAIL PROTECTED] (Gregory Stark) wrote: > "Norman Peelman" <[EMAIL PROTECTED]> writes: > >> My options are, as far as I can tell, > > >> 1) replace the Database PDO extending class with something else that > >> provides query results caching in PHP, or > >> 2) get Postgres itse

Re: [GENERAL] Query meltdown: caching results

2008-02-26 Thread Gregory Stark
"Norman Peelman" <[EMAIL PROTECTED]> writes: >> My options are, as far as I can tell, >> >> 1) replace the Database PDO extending class with something else that >> provides query results caching in PHP, or >> 2) get Postgres itself to cache the results of queries to avoid >> running them repeatedl

Re: [GENERAL] Query meltdown: caching results

2008-02-26 Thread Gordon
On Feb 26, 11:11 am, Gordon <[EMAIL PROTECTED]> wrote: > I'm working on a CMS that, in addition to the database-stored version > of articles for easy searching, sorting, etc, also stores a HTML file > version so pages can be fetched with the minimum of overhead (browsing > articles has no more over

Re: [GENERAL] Query meltdown: caching results

2008-02-26 Thread Norman Peelman
Gordon wrote: I'm working on a CMS that, in addition to the database-stored version of articles for easy searching, sorting, etc, also stores a HTML file version so pages can be fetched with the minimum of overhead (browsing articles has no more overhead than accessing any other HTML file on the

Re: [GENERAL] Query meltdown: caching results

2008-02-26 Thread Richard Huxton
Gordon wrote: I need to find a way of not running queries that I don't need to, either in the PHP script, or in the Postgres database. What I need is for a result set to be cached somewhere, either by Postgres or PHP, so when it sees the same query again in a given session it just returns the pr

[GENERAL] Query meltdown: caching results

2008-02-26 Thread Gordon
I'm working on a CMS that, in addition to the database-stored version of articles for easy searching, sorting, etc, also stores a HTML file version so pages can be fetched with the minimum of overhead (browsing articles has no more overhead than accessing any other HTML file on the server). As I'v