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 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.
-- Steven Lembark 85-09 90th Street Workhorse Computing Woodhaven, NY 11421 [EMAIL PROTECTED] 1 888 359 3508
