On 8/12/07, David Gerard dgerard@gmail.com wrote:
Wasn't the problem that queries on category intersections suck mud in MySQL? (But work very fast in Postgres. Thus demonstrating the superiority of MySQL. Hold on, I'll come in again ...)
But yes, a tagging system is necessary.
We're not stuck using MySQL when something else works better. :)
You have seen my intersection tool, yes?
For commons: http://tools.wikimedia.de/~gmaxwell/cgi-bin/cattersect.py
For enwiki: http://tools.wikimedia.de/~gmaxwell/cgi-bin/enwiki_cattersect.py
Tangotango and I are already working on moving mayflower over to my backend. ;)
Cheers.