Task #100932
closedSpeed up SysLogSerializationUpdate
100%
Description
During the upgrade to version 12 with a lot of entries in sys_log
, SysLogSerializationUpdate
takes quite a lot of time because it processes each row individually. This however is only necessary for rows where log_data is not a:0:{}
. I suggest adding a fast update command on all rows that have that value stored and afterwards process all other rows:
update sys_log set log_data = '[]' where log_data = 'a:0:{}';
Updated by Oliver Hader over 1 year ago
- Tracker changed from Feature to Task
- TYPO3 Version set to 12
Sounds like a good optimization for TYPO3 v12. Besides a:0:{}
I also found a:1:{i:0;s:0:"";}
in some my my TYPO3 projects.
Updated by Gerrit Code Review over 1 year ago
- Status changed from Accepted to Under Review
Patch set 1 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/79245
Updated by Gerrit Code Review over 1 year ago
Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/79245
Updated by Gerrit Code Review over 1 year ago
Patch set 1 for branch 12.4 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/79255
Updated by Anonymous over 1 year ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 7f40b8f3a6a4bbc82da01cb2b059ed9d5423e67d.