Symphony.

It seems like Symphony has a problem with deleting or emptying large sections:

So I’ve got heaps of records which I want deleted (490 pages or 8000 entries) and I need to delete them. I’ve tried the action in Sections to delete all entries for a section but I get a exceeded memory error.

http://www.getsymphony.com/discuss/thread/58421/1/

But isn’t that just a PHP/server config issue? Is the thinking here that the system should throttle the process on its own?

Is the thinking here that the system should throttle the process on its own?

I’m not sure but I thought it might be worth discussing.

Another possibility could be to rewrite the delete all-logic to use MySQL’s ability to delete all rows in a table in an instance:

DELETE FROM sym_entries_data_100;

and

DELETE FROM sym_entries WHERE `section_id` = $id;

TRUNCATE TABLE table_name

Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables.

More information: dev.mysql.com/doc/refman/4.1/en/truncate-table.html

See if this works: https://github.com/symphonycms/symphony-2/pull/85

This issue cannot be solved by simply changing SQL queries. See brendo’s comment here.