Issue Task Closed

#100932Speed up SysLogSerializationUpdate

Alexander Schnitzler 05/31/23, 05:49 updated 01/30/24, 08:32

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

  1. Oliver Hader commented and changed tracker Feature Task TYPO3 Version 12 06/01/23, 08:38

    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.

  2. Oliver Hader changed status New Accepted 06/01/23, 08:38

  3. Thomas Hohn changed assigned to Thomas Hohn 06/09/23, 08:09

  4. Gerrit Code Review pushed patch set 1 for main to change 79245 status Accepted Under Review 06/09/23, 08:38

  5. Gerrit Code Review pushed patch set 2 for main to change 79245 06/09/23, 12:31

  6. Gerrit Code Review pushed patch set 1 for 12.4 to change 79255 06/11/23, 21:41

  7. Anonymous commented and changed status Under Review Resolved done 0 % 100 % 06/11/23, 22:00

    Applied in changeset commit:7f40b8f3a6a4bbc82da01cb2b059ed9d5423e67d.

  8. Benni Mack changed status Resolved Closed 01/30/24, 08:32