Optimized IP Address Pruning Process
authorSascha Greuel <github@1-2.dev>
Sun, 25 Feb 2024 16:05:33 +0000 (17:05 +0100)
committerSascha Greuel <github@1-2.dev>
Sun, 25 Feb 2024 16:05:33 +0000 (17:05 +0100)
commit685c665ff4cbd9036857d22bd1c1dd6b96562ffe
treee550338663408971e4a2d9a038a1864264ee0fbd
parentad54d1cce134592558c643887130ac79e4168eab
Optimized IP Address Pruning Process

Currently, when pruning IP addresses, each row within the database tables is examined, including those that have already been processed. This approach can significantly slow down queries in large communities. To enhance efficiency, it is proposed that rows with already processed (empty) IP addresses be excluded from further processing.

This PR optimizes the IP address pruning process by excluding rows where the IP address has already been cleared, thereby reducing unnecessary database query processing.
wcfsetup/install/files/lib/system/cronjob/PruneIpAddressesCronjob.class.php