Wikia/app — pull request #52 by Grunny (2012-11-06 03:03:25+00:00)
Title: (BugID: 51784) Improving Phalanx IP check performance

This significantly improves the execution time of the UserBlock::blockCheck method (the slowest by far for Phalanx) for IP addresses (by about 84% for logged-out users and 42% for logged in users from data collected during testing on devboxes), and replaces ~3,000 calls per blockCheck on an IP to Phalanx::isBlocked with one call to blockCheckIP.

Will require running a script to update the Phalanx table to populate the new column, which I have ready as well.