Simetrical wrote:
On Fri, Feb 22, 2008 at 5:59 AM, Samuel Wantman wantman@earthlink.net wrote:
While designing tables for categories, I hope that some thought be given into implementing category intersection. I suspect the process would be much faster with properly designed tables.
Unfortunately, no. The way to do this effectively is probably just to use a fulltext index. MySQL's fulltext system is not really acceptable for Wikimedia use (too slow, only works on MyISAM),
"Too slow" depends on actual usage. Unless you've benchmarked it in that usage, I wouldn't toss that word around yet.
Being relegated to a MyISAM table isn't necessarily an issue, either. MyISAM has some issues, but there's nothing preventing us from using it when and where required.
The main issues are:
* May require error checking after a server crash
(Annoying, but a) can be automated and b) doesn't have to interfere with everything else.)
* Doesn't participate in transactions
(Probably not that big a deal. Certainly no worse than creating yet-another external server.)
* Reade and writes can hold conflicting locks, and you may have to wait on things sometimes.
(Probably not that bad in this kind of case.)
-- brion vibber (brion @ wikimedia.org)