Saving large file

I have create a function to export database tables to Excel files.

When my result set reach around 1500 rows, I start getting memory
errors.

I worked around the download issue using the flush() function but I
now get errors like:

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to
allocate 40 bytes) in /dev/cake/libs/model/datasources/dbo/
dbo_mysql.php on line 452

What is the appropriate way to deal with this kind of problem?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---