 |
|
 |
|
- Readme First! -
Read and follow the rules, otherwise your posts will be closed |
|
|
|
|
|
There are currently, 169 guest(s) and 0 member(s) that are online.
You are Anonymous user. You can register for free by clicking here |
|
|
|
|
|
Increase your Forums Performance |
|
 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.
|
|
Posted on Tuesday, January 27 @ 20:40:49 CET by Zhen-Xjell |
|
|
|
|
| |
|
Average Score: 4.33
Votes: 6
|
|
|
|
|
|
|
| | The comments are owned by the poster. We aren't responsible for their content. |
| | | | |
| No Comments Allowed for Anonymous, please register | | | | |
Re: Increase your Forums Performance (Score: 1)
by jimmyjimjim on Tuesday, January 27 @ 21:44:32 CET
(User Info | Send a Message) | I don't really understand... Are there any changes we should make to any of the forum scripts?
Will this work for a 6.5 site? |
| | | | |
Re: Increase your Forums Performance (Score: 1)
by georgiaguy on Wednesday, January 28 @ 08:33:58 CET
(User Info | Send a Message) | | what type of performance increase can be expected (what did you see here)? why does adding this post_id index yield the increase with no other changes to forum code? |
| | | | |
Re: Increase your Forums Performance (Score: 1)
by jimmyjimjim on Wednesday, January 28 @ 09:11:46 CET
(User Info | Send a Message) | ZX... First off let me start by saying thank you. YOu have shown the community here over and over again that you are willing to go above and beyond the call to help teach us as well as make these wonderful hacks/scripts/modules/etc. avaialbe.
Will this INDEX apply to every entry made after the fact as well?
I guess what I'm asking is this a one time solution or does this have to be scheduled? |
| | | | |
Re: Increase your Forums Performance (Score: 1)
by Paul_k on Wednesday, January 28 @ 15:40:23 CET
(User Info | Send a Message) | Hi,
Is the remove index command wrong? Looks like it should be..
ALTER TABLE nuke_bbsearch_wordmatch DROP INDEX post_id; |
| | | | | |
|
