Issue Task Closed

#85300Improve record sorting performance

Tymoteusz Motylewski 06/18/18, 13:14 updated 10/02/18, 10:46

Description

Currently when TYPO3 inserts a record to a table which is position aware ($GLOBALS[‘TCA’][$table][‘ctrl’][‘sortby’] is set), it needs to calculate sorting value.
If there is no “sorting space” left between elements, the whole table needs to be resorted.

TYPO3 now does 1 update query per row in the table.
Instead we should make 1 update query to update all rows.

Additionaly the algorithm of calculating the next sorting value should be improved to allow more space between rows == meaning that full resorting will happen less often.

Reviews 3