I know that I have had problems with low memory before when php started at 16mb ( i think) used per script. You might look in php.ini and increase the amount of memory allowed for each script.
As for releasing memory already used, not sure how to do that if you are actually trying to pull down 5000 records at one time. BTW, 128KB per record is HUGE, so there must be a lot of text in each one. If the average size of your records needs to be so large (you can't exclude some data) you should look at paging the recordset and pulling down 20 or 30 at a time. You can do this with propel straight off (but I don't recall how) or by using a custom query. HTH, // Andrew Another thing you might look at, if the access times aren't bad, is retrieving just a list of the IDs and then getting the records one at a time. On 14/03/07, ved <[EMAIL PROTECTED]> wrote: > > > Hi Friends, > > I have a table with close to 5000 records, to process them I have > written a small application thats suppose to run as a cron job. After > processing 1500 records it fails with this error message > > Quote: > > PHP Fatal error: Allowed memory size of 20971520 bytes exhausted > (tried to allocate 1177 bytes) in /usr/home/project/e4s-demo/lib/ > symfony/vendor/creole/drivers /mysql/MySQLResultSet.php on line 57 > > > Each Record size < 128 KB > > I think the problem is with Creole, that also keeps all the previous > executed Queries in the memory. Increasing PHP memory cannot be a > solution since it is able to process 1500 records, and creole doesn't > need to keep the previous queries details in memory. > > Has anyone faced this problem ? > > Thanks and Regards > > [ Also posted on forum ] > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony developers" 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-devs?hl=en -~----------~----~----~----~------~----~------~--~---
