Increase your Forums Performance
Date: Tuesday, January 27 @ 20:40:49 CET
Topic: PHP-Nuke


Due to the large size of the database for Nuke Cops, our nuke_bbsearch_wordlist has grown very large. Now by default phpbb doesn't include an index in that table which can make your forum slow down. Running the SQL command below will increase that table size (could double it), but a performance increase is expected with the index.

ALTER TABLE nuke_bbsearch_wordmatch ADD INDEX post_id (post_id);

Please note, run this during a time on your site when it is least busy. More records on that table means longer run time. As an example, it took about 1 minute to run it on Nuke Cops -- with high powered CPUs.

If you find that this doesn't work for you, run this to remove the index:

ALTER TABLE nuke_bbsearch_wordmatch DROP INDEX post_id;

BACKUP BEFORE DOING ANYTHING! With that disclaimer, I'd like to point out that nothing bad happened here or at ComputerCops.biz when I ran it.





This article comes from NukeCops
http://www.nukecops.com

The URL for this story is:
http://www.nukecops.com/modules.php?name=News&file=article&sid=1480