Re: cursors and sessions
| От | Aaron Bono |
|---|---|
| Тема | Re: cursors and sessions |
| Дата | |
| Msg-id | bf05e51c0803131604k1dcebe8fo574cd218a3cd3e07@mail.gmail.com обсуждение |
| Ответ на | cursors and sessions (chester c young <chestercyoung@yahoo.com>) |
| Список | pgsql-sql |
On Thu, Mar 13, 2008 at 5:54 PM, chester c young <chestercyoung@yahoo.com> wrote:
Why not pump your data into a table that mirrors the cursor and then create a function that pops items off the top of this queuing table as needed by the different sessions?
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
is there any way to share a cursor between sessions?
I have a costly query whose records need to be visited by in order by n
number of concurrent sessions, and am unable to find the best way of
doing this.
I'd almost like to write a daemon that hands out the next record, but
that's a royal pain to set up and maintain.
Why not pump your data into a table that mirrors the cursor and then create a function that pops items off the top of this queuing table as needed by the different sessions?
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================
В списке pgsql-sql по дате отправления: