> > 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