#100932Speed up SysLogSerializationUpdate
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:{}';Reviews 2
History 58
-
Oliver Hader commented and changed tracker
FeatureTask TYPO3 Version 12 06/01/23, 08:38 -
Oliver Hader changed status
NewAccepted 06/01/23, 08:38 -
Thomas Hohn changed assigned to Thomas Hohn 06/09/23, 08:09
-
Gerrit Code Review pushed patch set 1 for main to change 79245 status
AcceptedUnder Review 06/09/23, 08:38 -
Gerrit Code Review pushed patch set 2 for main to change 79245 06/09/23, 12:31
-
Gerrit Code Review pushed patch set 1 for 12.4 to change 79255 06/11/23, 21:41
-
Anonymous commented and changed status
Under ReviewResolved done0 %100 % 06/11/23, 22:00Applied in changeset commit:7f40b8f3a6a4bbc82da01cb2b059ed9d5423e67d.
-
Benni Mack changed status
ResolvedClosed 01/30/24, 08:32
Sounds like a good optimization for TYPO3 v12. Besides
a:0:{}I also founda:1:{i:0;s:0:"";}in some my my TYPO3 projects.