Re: DBI memory usage

2005-01-18 Thread Fred Moyer
>> > It looks like $r->child_terminate does what I need. In the case of >> > Postgresql it eats the memory when you execute the query, regardless >> > of whether you actually fetch any results. >> >> That can be worked around, however. By using a cursor, you can specify >> exactly how much data yo

Re: DBI memory usage

2005-01-18 Thread Fred Moyer
>> > It looks like $r->child_terminate does what I need. In the case of >> > Postgresql it eats the memory when you execute the query, regardless >> > of whether you actually fetch any results. >> >> That can be worked around, however. By using a cursor, you can specify >> exactly how much data yo

Re: [mp2] - modperl-2.0.0-RC3 fails tests after build

2005-01-18 Thread Philippe M. Chiasson
Timour Ezeev wrote: Hello All: -8<-- Start Bug Report 8<-- 1. Problem Description: Mod_perl-2.0.0-RC3 fails tests after successful compilation. I'm trying to build latest mod_perl with apache-2.0.52. The compilation is successful but a few tests are fa

Re: DBI memory usage

2005-01-18 Thread Chris Ochs
On Tue, 18 Jan 2005 10:43:02 +, Peter Haworth <[EMAIL PROTECTED]> wrote: > On Mon, 17 Jan 2005 17:46:17 -0800, Chris Ochs wrote: > > It looks like $r->child_terminate does what I need. In the case of > > Postgresql it eats the memory when you execute the query, regardless > > of whether you ac

Re: Apache::Request

2005-01-18 Thread B. Duffee
Thanks Randy, My tired eyes missed the required Apache 1.3 in the rush to get everything else in place. I imagine that WebWork was trying to move to mod_perl 1.29 at the time. I've just been caught in the awful predicament of regressing to Apache 1.3 or hacking WebWork. (Ohh, the curse of op

Re: Apache::Request

2005-01-18 Thread Randy Kobes
On Tue, 18 Jan 2005, B. Duffee wrote: > Thanks for the advice. I did try installing libapreq2, > but Apache::Constants has changed name and the dependancy > checker for the package I'm installing flagged it up as > missing. The problem is I'm not the one who's writing the > code. I'm installing

Re: Apache::Request

2005-01-18 Thread B. Duffee
Thanks for the advice. I did try installing libapreq2, but Apache::Constants has changed name and the dependancy checker for the package I'm installing flagged it up as missing. The problem is I'm not the one who's writing the code. I'm installing WebWork2 ( http://webwork.math.rochester.edu/

Re: DBI memory usage

2005-01-18 Thread Sean Davis
On Jan 17, 2005, at 11:44 PM, Chris Ochs wrote: Also ask yourself if you really need all of the data at once. You may be able to filter it down in the query or build some incremental data structures using row-by-row iteration instead of fetchall_arrayref. Ya I do, it's basically a customer list exp

Re: DBI memory usage

2005-01-18 Thread Peter Haworth
On Mon, 17 Jan 2005 17:46:17 -0800, Chris Ochs wrote: > It looks like $r->child_terminate does what I need. In the case of > Postgresql it eats the memory when you execute the query, regardless > of whether you actually fetch any results. That can be worked around, however. By using a cursor, you