From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
Cc: | Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>, <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: Using Cursors in PHP |
Date: | 2003-08-08 13:22:18 |
Message-ID: | Pine.LNX.4.33.0308080721170.20444-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
On 8 Aug 2003, Markus Bertheau wrote:
> РСÑд, 06.08.2003, в 17:51, scott.marlowe пиÑеÑ:
> > On Wed, 6 Aug 2003, Andreas Schmitz wrote:
> >
> > >
> > > Hello *,
> > >
> > > I am just wondering if it is possible to use cursors within PHP. I need to
> > > page query result from a big table and I am looking for a solution to avoid
> > > scanning the complete table using limit and offset.
> >
> > Yes, you can use cursors, no you can't expect them to survive from one
> > page to the next.
>
> What about the new feature in cursors "WITH HOLD"? Don't they survive?
I don't think so. Basically, PHP is supposed to reset the connection if
it's persistant, and if it isn't persistant, then it's always a new
connection, which means a cursor shouldn't survive.
But I'm NOT familiar with "WITH HOLD" right now, so someone else who knows
that better may have a more definitive answer.
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-08-08 13:33:25 | Re: Using Cursors in PHP |
Previous Message | Markus Bertheau | 2003-08-08 08:01:40 | Re: Using Cursors in PHP |