On 4/10/07, David Gerard <dgerard(a)gmail.com> wrote:
Technical note: it appears to work much more nicely in
PostgreSQL than
MySQL - but the chances of Wikimedia's servers moving off MySQL are
about zero.
What is "it" exactly? What is the proposal that is so demanding in
MySQL, and why is it so demanding? There would seem to be many ways of
reducing the complexity of the queries, such as forcing the unions to
be defined ahead of time and cached. That is, "American saxophonists"
would be a category created by someone that includes the tags
"American" and "saxophonist", but you couldn't just randomly query
the
database for "American bananas that died of lung cancer in Futurama".
Steve