Sumedh, I have recently been writing Symfony batch scripts (1.0) to export large sets of data into Excel / CSV (over 200,000 rows). I hit the same issue over and over again.
The only way I manage do solve this is by-pass propel in total. You can still use Symfony with Cerole and bypass Propel - this is what I did, so you still have a layer of db abstraction. I used unset() quite a bit, that helped a little bit, but still had issues. In your logs make sure you do some number_format (memory_get_usage()) to see if the unset is actually clearing anything. Hope this helps Sherif http://symfonynerds.com On Nov 12, 10:35 pm, Sumedh <[EMAIL PROTECTED]> wrote: > Hi Friends, > > I am getting a out of memory error in a batch script. > > 1. I am using Symfony 1.0 on PHP 5.1.2 > > 2. I am fetching some data from table1, doing some calculations > (average, standard deviation etc.) and storing it in table2. > > 3. There are no circular references as far as I can see. > > 4. I tried using unset() on all possible places for arrays and > resultsets I am using, but the memory allocation goes on increasing > monotonically. > > 5. My PHP memory setting is 24MB which should be enough, as the data > set is not very large. In one loop, I am handling only thousands of > records, not hundreds of thousands. > > Does it have something to do with Propel? Can I call some method to > release memory after every loop? > > - Sumedh --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
