26

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?

27

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 tongue Would be nice to be able to disable these in the admin panel smile

28

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

29

Re: Punbb search performance tweak

I'm glad to introduce worf, the guy who wrote the patch in the first post of this topic smile

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... big_smile