I have a problem domain where there are lots of messages to be indexed, and I want to be able to limit them by a set of groupids.
Essentially, each group is a subgroup of another group. Something like this:
(((WebsiteID,AreaOfWebSiteID),SubAreaOfWebSiteID),ForumID)
And an alternate:
(WebsiteID,UserID)
All in addition to the keywords.
I’m fine with just using Sphinx for now, but want to use its MySQL integration at some point as well.
Just not sure how to get started…