Mass delete error | blank screen | php timeout?

[koo]

Hello

I'm having this problem with mass delete.

Lets say that we have 50.000 accounts and I'll select "All accounts" and "delete" at Account List page. Page loads for a few seconds (max) and then the result is a blank screen. About 250 records were deleted. I raised php.ini settings and now it was able to delete 650 records before blank screen.

System settings:
SUGAR 5.5 / 5.2.0k (production and test enviroments).
Apache
PHP 5.2.12
MySQL 5.0.77

php.ini:
upload_max_filesize 32M
post_max_size 32M
memory_limit 64M

It might be possible to convince our webhost to raise values more, but would it matter with that large number of records like this?

Shouldn't Sugar work OK when recommended settings to php are reached?

[salesagility]

what errors are you getting in sugar.log?

[koo]

Hi salesagility and thanks for your reply.

Sugarcrm.log file shows no related errors.. There are few log entries like this:
Fri Feb 12 14:45:42 2010 [16774][1][FATAL] accounts.name like '0000000-3%'
but it likely don't have anything to do with this problem?

[salesagility]

This is a memory issue ... you should ask your webhost to increase the max script execution time and memory limit ... there's no defined rule but with the size of deletes you're doing, then I'd experiment by doubling these values until the problem goes away

[koo]

This is a memory issue ... you should ask your webhost to increase the max script execution time and memory limit ... there's no defined rule but with the size of deletes you're doing, then I'd experiment by doubling these values until the problem goes away

Thanks for your help, I'll ask my host for this.