huge memory needs for deleting large number of records

**vronp** · 2010-04-25, 12:34 PM

Hi all,

Today I had the need to delete 50,000 account records. After selecting them all and deleting, Sugar would delete a couple hundred and then "die".

In php.ini I have been increasing the memory_limit value up to 1.5 GB !!! Now I can deleted about 6000-7000 records at a time. Also, I have the script execution time up to 60 seconds.

This doesn't seem right. Any ideas?

CentOS 5.4
Latest apache, php, and mysql.

Sugar Version 5.5.1RC (Build 1141) Community Edition

thanks !

**turutosiya** · 2010-04-25, 04:28 PM

try delete directly from db with sql, not through sugar.

**vronp** · 2010-04-25, 05:36 PM

Originally Posted by turutosiya

try delete directly from db with sql, not through sugar.

Yes, I realize that is always an option. Would prefer to use Sugar though.

**kbrill** · 2010-04-25, 06:15 PM

This is bug #34180, it's still on the schedule but I don't have a release date for it. I expect it will be addressed sometime after we move to PHP 5.3 and it's new garbage collection stuff.