[wp-hackers] lots of category items

[Haluk Karamete]

That's exactly what I had gotten out of that article. Thank you once again
for clarifying.
It's probably very very hard to pass a judgement over whether the 3 joins
crossing media=video audience=beginners featured=must-see is really a big
deal or not! My puzzle is this.

The web site I have to help build has 100K visitors per day, a content
heavy web site with lots of landing pages that paints a magazine/news style
look and feel. now I can implement  their database with 3 taxonomies or
with a single taxonomy ( built in category that is ).  Since taxonomy route
results the   "lots of category titles" - hence the title of this email.
And 3 taxonomies results 3 nice boxes in the admin screen making the data
entry much more enjoyable.

The question is if the speed concerns you raised in your article warrants
that we go with one taxonomy and live with the "lots of category items" or
not.

On Thu, Apr 5, 2012 at 3:30 PM, Otto <otto at ottodestruct.com> wrote:

> On Thu, Apr 5, 2012 at 5:10 PM, Haluk Karamete <halukkaramete at gmail.com>
> wrote:
> > It was Otto's article (WordPress 3.1: Advanced Taxonomy Queries) that
> > suggested me the otherwise.
> >
> > Cause it ends with this
> >
> >>Speed Concerns
> >>Advanced taxonomy queries are cool, but be aware that complex queries are
> > going to be slower. Not much slower, since the >code does attempt to do
> > things smartly, but each taxonomy you add is the equivalent of adding a
> > JOIN. While the relevant >tables are indexed, joins are still slower than
> > non-joins.
>
>
> In that article, you'll notice how I'm writing queries that depend on
> multiple taxonomies, yeah? Well, each taxonomy you add means that the
> query to get those posts has another JOIN. One taxonomy in the query =
> one JOIN. Two taxonomies in the query = two JOINs. And so forth.
>
> > However, I don't think that's the case. I think each taxonomy you create
> > comes back at you as a join in the relavant query.
>
> Each taxonomy *in your query* adds a join *to that query*. You can
> have a million taxonomies, but if you're only querying against one of
> them, then it's only one JOIN.
>
> -Otto
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>