projects / GitHub / WoltLab / WCF.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 929be85) | patch
Improve the rebuild of users
authorAlexander Ebert <ebert@woltlab.com>
Fri, 12 Apr 2024 20:29:03 +0000 (22:29 +0200)
committerAlexander Ebert <ebert@woltlab.com>
Sat, 8 Jun 2024 10:31:07 +0000 (12:31 +0200)
commit6511b11741eebd63645d1a193f0c05b962884f2c
tree1d68acbc12bbc6f05b9901600081d307e050d04dtree | snapshot (tar.gz zip)
parent929be85930f7ea058c4f5f3daad46b90bf65a731commit | diff
Improve the rebuild of users

The regular query using `LIMIT` and `OFFSET` is painfully slow with large datasets.

Rebuilding 500k users previously took about 3 hours, afterwards the same action can be carried out in about 20 minutes.
wcfsetup/install/files/lib/system/worker/UserActivityPointItemsRebuildDataWorker.class.php diff | blob | blame | history
wcfsetup/install/files/lib/system/worker/UserRebuildDataWorker.class.php diff | blob | blame | history
WoltLab Suite Core (previously WoltLab Community Framework)