Simetrical wrote:
On Fri, Feb 22, 2008 at 5:59 AM, Samuel Wantman
<wantman(a)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)