If recursive = 0 or recursive = -1 doesn't give you all wanted data use contain to minimize the data you export. I had the same problem with an xml export and this heleped.
Anja
-----Ursprüngliche Nachricht-----
Von: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] Im Auftrag von lemp
Gesendet: Dienstag, 2. Dezember 2008 02:35
An: CakePHP
Betreff: 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
-~----------~----~----~----~------~----~------~--~---
No comments:
Post a Comment