Slow Sourcebans Ban List Loading Fix

[soja]

With the most recent version of mysql server(5.6+) and the changes to how joining tables works, loading your sourcebans ban list can take an extremely long time. This isn't a performance issue with NFOs web hosting. This will happen anywhere that has an updated version of MySQL server.

I have attached a file that should be extracted and placed inside the "pages" folder of your sourcebans install. The only change made in this file is on line 40, and I add this mysql query:

Code: Select all

set session optimizer_switch='block_nested_loop=off';

Even if your ban list doesn't take a long time to load yet, as your ban list grows you can expect load times to grow with it.

I wouldn't expect the sourcebans team to update 1.4.x with this small fix, so this is probably your only solution.

If you experience any problems with this, please let me know via steam(you can add me through my signature).