We've run into some performance issues on one of our big boards (6.5M Bposts, 110K Users)caused by MySQL FT search
As I did not want to "cripple" search much I started a Sphinx implementation from scratch, which so far seems to work pretty well (all search options do work, but I am not yet using Sphinx for everytinh that would be possible).
One thing I've noticed with this approach is that ID selects from the post table (like for user post search) are still kinda slow even though FT is not invloved.
So I went ahead and created a new table that only contained the meta data (visible, threadid, etc.) and ran the queries against this table (currently updated via plugins, I might change this to use triggers) - which seems to be quite a lot faster.
Has anybody made similar experiences?
02-14-2010, 01:56 PM
Splitting the post table
Hybrid Mode
