Re: caching query results

hello dear people without shaved necks!

as many of you have already told me cursors are the way to go - now I know!

there it is, kindly provided my BILL G.:

BEGIN;
DECLARE <cursorname> FOR <query>;
FETCH <number_of_rows> FROM <cursorname>;
MOVE {FORWARD|BACKWARD} <number_of_rows> IN <cursorname>;

THANK YOU ALL VERY VIEL (much in german)!!!

I will now have to implement session ID's into my CGI's...

oh by the way... lets say a transaction has begun and was never
commited.. what will happen to it?

is there a automatic rollback after a certain time?
or would there be ton's of open transactions?

Darko Prenosil wrote:
> 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)
>
>
>