| From: | Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr> |
|---|---|
| To: | "alex b(dot)" <mailinglists1(at)gmx(dot)de>, Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: caching query results |
| Date: | 2003-05-21 18:10:46 |
| Message-ID: | 200305212010.46062.darko.prenosil@finteh.hr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)org)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-05-21 18:12:36 | Re: Installing PlPerl |
| Previous Message | Darko Prenosil | 2003-05-21 18:08:29 | Re: [HACKERS] about NULL |