Details
-
Improvement
-
Resolution: Fixed
-
High
-
3.10.1, 4.0.1
-
None
Description
Currently, deleting multiple items in eZ Cluster uses a name LIKE 'path/to/item/%' query. These are bad for performances, and can actually lead to bad deadlocks and long publishing times.
A way to fix this is to use a new field in the ezdbfile table, name_trunk, that is set to the common value that can be used to delete multiple files (for instance var/xxx/cache/content/2- for root node viewcache items).
Deleting is much much faster this way and it reduces deadlocks a lot.