> > 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 export from the database that I write out to a temp file, archive using zip, and then print it to the browser. However I am just iterating over a fetchrow, not using fetchall. DBD::Pg sticks everything into memory when you run the query, before you fetch anything. Chris > > -- > Steven Lembark 85-09 90th Street > Workhorse Computing Woodhaven, NY 11421 > [EMAIL PROTECTED] 1 888 359 3508 >