caching query results - Mailing list pgsql-general

From alex b.
Subject caching query results
Date
Msg-id 3ECB8E7A.2060704@gmx.de
Whole thread Raw
Responses Re: caching query results  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: caching query results  (Darko Prenosil <darko.prenosil@finteh.hr>)
List pgsql-general
hello all


I've been wondering, if it was possible to cache the query results...

the reason I ask is because of a script I wrote recently... each request
takes up to 4 seconds... that ok, because its quite a bit of data... but
instead of always collecting the data again and again some kind of cache
wouldn't be all too bad.

assuming that all queries are always the same - except for the OFFSET..
- LIMIT stays the same.

cheers, alex


pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: DBI connection to multiple database
Next
From: Joseph Healy
Date:
Subject: Re: TIMESTAMP SUBTRACTION