Large Result and Memory Limit

Hello,
  I am working on a personnel registry that has upwards of 50,000
registrants.  Currently I am working on an export module that will
create a CSV from multiple tables.  I have managed to keep the script
(PHP) under the memory limit when creating and inserting the CSV into
the database.  The problem comes when I try to query for the data and
export it.  Memory limit is a major concern, but the query for one row
returns a result set too large and PHP fails.

I've thought about storing the data in multiple rows and then querying
one-by-one and outputting, but was hoping there was a better way.

Thanks in advance for the help.

MG

Mike Ginsburg
Collaborative Fusion, Inc.
mginsburg@collaborativefusion.com
412-422-3463 x4015