Re: [GENERAL] DBD::Pg behavior for large queries

2005-01-19 Thread Peter Haworth
On Tue, 18 Jan 2005 10:38:24 -0800, Chris wrote: > The DBD::Pg man page say's this about cursors. What I don't > understand is the nested selects being in a different transactions. > Can someone clarify for me what is being said here? Does this > basically mean that I can use cursors in DBD::Pg, I

[GENERAL] DBD::Pg behavior for large queries

2005-01-18 Thread Chris
I'm using DBD::Pg under mod perl, and I'm trying to find a way to workaround the fact that DBD::Pg fetches all the data at once in a query and sticks it into memory before you execute a fetch. Right now I'm having to kill the apache child after it's finished running in certain cases, and I'd rathe