Re: caching query results

On Wednesday 21 May 2003 16:34, alex b. wrote:
> 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
>

The only way is to use cursor or temp table.

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)