Re: Punbb search performance tweak
Yann wrote:
.. but I think it was because of a too small key_buffer_size ...
What was the key_buffer size setting that worked best for you?
- sirena
- Senior Member
- Offline
Re: Punbb search performance tweak
sirena > it depends on the size of the indexes of your forum (as far as I understood, i'm not quite good in sql, and usually gets help for this).
The key_buffer_size should be bigger as the size of your indexes; but you should be careful to have enough RAM so mysql don't need to swap (which would be really bad).
By the way, I disabled the wildcards in the search, a query on %wifi% just killed my forum 
Would be nice to be able to disable these in the admin panel 
Re: Punbb search performance tweak
This is a new patch to simplify a query by removing a useless GROUP BY (no count in the query)
http://www.skyblog.com/punbb-1.2.14_search.php.patch
Re: Punbb search performance tweak
I'm glad to introduce worf, the guy who wrote the patch in the first post of this topic
Re: Punbb search performance tweak
Hi Worf,
Thanks for the patches. Much appreciated.
We removed the useless group by in subversion a couple of weeks ago. We haven't backported the change to the 1.2 tree though.
http://dev.punbb.org/changeset/669
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: Punbb search performance tweak
Could someone explain me how to apply Worf's patch in WAMP platform? I'm out of my league here... 