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-22 08:39:30 |
Message-ID: | 200305221039.30296.darko.prenosil@finteh.hr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday 21 May 2003 20:26, alex b. wrote:
> 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?
>
In context of one connection, You can not start next transaction until
previous transaction is not ROLLBACK or COMMIT-ed. Transaction will close
with connection (maybe someone from hackers team might tell You more).
> 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)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | A.Bhuvaneswaran | 2003-05-22 09:11:29 | Re: Installing PlPerl |
Previous Message | Thomas Beutin | 2003-05-22 07:59:07 | Re: compiling mod_auth_pgsql |