 |
|
 |
|
- Readme First! -
Read and follow the rules, otherwise your posts will be closed |
|
|
|
|
|
There are currently, 315 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 Zhen-Xjell on Tuesday, January 27 @ 21:59:43 CET
(User Info | Send a Message) http://castlecops.com | | No changes at all to the forum scripts, or any script. This is a change to the MySQL table: nuke_bbsearch_wordmatch. This will create a new index that'll help increase forum performance. |
]
| | | | |
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 Zhen-Xjell on Wednesday, January 28 @ 08:52:11 CET
(User Info | Send a Message) http://castlecops.com | | Any kind of index one creates in a table increases database performance -- although the size nearly doubles too. We had the same issue with PHP-Nuke prior to version 6. Performance increase will vary for everyone depending on the size of the table and how many queries are being sent to the database. |
]
| | | | |
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 Zhen-Xjell on Wednesday, January 28 @ 09:38:18 CET
(User Info | Send a Message) http://castlecops.com | Hi & thanks. You make be blush. ;)
Yes its a one time alteration. It'll go thru each record as you apply it, and going forward it will affect all new entries.
|
]
| | | | |
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; |
| | | | | |
|
