Re: DBI memory usage

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

From: Chris Ochs
Subject: Re: DBI memory usage
Date: 01:46 on 18 Jan 2005

> > Yes.  Many databases support sending the results a few rows at a time
> > instead of all at once.  For specific advice on this, you might check
> > your DBD documentation or ask on the dbi-users list.  You can also have
> > your program schedule the current apache process to exit after finishing
> > the current request if you load a large amount of data into it.
> 
> Also, see http://modperlbook.org/html/ch20_02.html.

Thanks Perrin,

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.

Chris

(message missing)

DBI memory usage
Chris Ochs 01:06 on 18 Jan 2005

Re: DBI memory usage
Perrin Harkins 01:18 on 18 Jan 2005

Re: DBI memory usage
Perrin Harkins 01:23 on 18 Jan 2005

Re: DBI memory usage
Chris Ochs 01:46 on 18 Jan 2005

Re: DBI memory usage
Peter Haworth 10:43 on 18 Jan 2005

Re: DBI memory usage
Chris Ochs 18:12 on 18 Jan 2005

Re: DBI memory usage
Peter Haworth 11:12 on 19 Jan 2005

Re: DBI memory usage
Steven Lembark 04:26 on 18 Jan 2005

Re: DBI memory usage
Chris Ochs 04:44 on 18 Jan 2005

Re: DBI memory usage
Sean Davis 11:03 on 18 Jan 2005

Re: DBI memory usage
Fred Moyer 21:10 on 18 Jan 2005

Re: DBI memory usage
Fred Moyer 21:11 on 18 Jan 2005

RE: DBI memory usage
Theo Petersen 15:51 on 19 Jan 2005