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.
[EMAIL PROTECTED]
412-422-3463 x4015


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to