Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
3.0.4
-
None
-
PHP Environment:
Database: MySQL(i) 5.0.32
Description
I recently found a scalability problem in here, where if the banlist is large (for example, the forum is using a ready-made list of known forum spammer IPs) the function would make an ambiguous query, which could include many thousands of result rows. This would cause slow execution time, and possible PHP memory limit exceptions and/or maximum execution time exceptions, not to mention high memory and processor usage in general.
I have written a patch for the issue, but don't know what the right channel to go through to submit it is on phpBB.
Attachments
Issue Links
- duplicates
-
PHPBB3-9687 Changing IP banning to use 'longest prefix matching' / CIDR based bans
-
- Patch Awaiting Review
-
- is duplicated by
-
PHPBB3-12463 ban users list performance
-
- Closed
-