From: "Jochem van Dieten" <jochemd@stripped>
> > After adding a column for "one level up", adding indexes, optimizing the
> > query it took only a few hundreds of seconds.
> Maybe I misunderstand the problem, but I get the impression you have
> the category computers>internet>providers>adsl and you want to count
> everything in computers>internet>providers. Isn't that just a BETWEEN
> 'computers>internet>providers' AND 'computers>internet>providers>z'
> which a B+tree is supposed to handle just fine?
If I remember it well we had to do something like:
So it was not simply a computers>internet>providers>adsl% , but
> > I really don't know how much hardware you would like to use to get these
> > results?
> For DMOZ data I don't want hardware, I want GiST indexes:
OpenLDAP could also work well I guess ;-)
Anyhow, the point I was trying to make was that it isn't just a question of
adding more hardware to get performance. More often than not a few
modifications will make a query pretty fast.
Yes, the query optimizer could be improved, but for a fast and reasonably
light DMS MySQL isn't bad at all!