Re: DBI memory usage

[prev] [thread] [next] [Date index for 2005/01/19]

On Tue, 18 Jan 2005 10:12:06 -0800, Chris Ochs wrote:
> On Tue, 18 Jan 2005 10:43:02 +0000, Peter Haworth
> <pmh@xxxxxx.xxxxxxxxxxxxx.xxx> wrote:
> > By using a cursor, you can specify exactly how much data you want
> > at a time:
>
> DBD::Pg doesn't support cursors. From the DBD::PG manpage:
>
>   "Although PostgreSQL has a cursor concept, it has not been used in
>   the current implementation."

No, that says that DBD::Pg doesn't *use* cursors in its implementation.
It certainly doesn't stop you from using them yourself. From DBD::Pg's
point of view, using cursors is exactly like executing any other SQL
query.

The code I posted was based on that used in 2 or 3 working applications
of mine, all of which use DBD::Pg, so it's not like I've posted
completely untested code based on guesswork.

        -- 
        	Peter Haworth	pmh@xxxxxx.xxxxxxxxxxxxx.xxx
"Maybe that's [Java's] niche, it's a language for people who like pain."
		-- Dean Wilson