Re: DBI memory usage

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

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

Perrin Harkins wrote:

> Chris Ochs wrote:
> 
>> Is there a way to do large queries that return lots of data without
>> having my apache process grow by the equivalent size in ram of the
>> data returned?
> 
> 
> 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.

- Perrin

(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