[wp-hackers] lots of category items

[Casey Bisson]

Haluk:

I'm not sure your presumptions about query performance for multiple taxonomies are correct.

WP3.4 is making some changes in this area that I haven't looked at, but a I think a taxonomy query with multiple terms is same whether or not those terms are in the same taxonomy. By the time the MySQL is generated, it's just a bunch of term_taxonomy_ids, whether those represent category terms or some mix of taxonomies is irrelevant.

--Casey Bisson
http://maisonbisson.com/
http://wordpress.org/extend/plugins/scriblio/

On Apr 3, 2012, at 8:58 PM, Haluk Karamete wrote:

> An alternative to this is to use custom taxonomies. I could create 4-5
> custom taxonomies such as media, topics, audience, collections, and
> feature. As a result of this. I could get 5 or 6 different islands (
> dropboxes ) that are each easy to get to. The problem with that would
> manifest itself when I run queries that are tapping into those multiple
> taxonomies.
> 
> Since I expect high traffic and lots of landing pages with a ton of loops,
> I do not want to go that route - just for the sake of getting individual
> boxes on the admin screen at content entry time.
> 
> I do not want to cross multiple taxonomies when pulling posts.
> 
> for example from media, get the videos AND intersect that with from
> audience the beginners stuff AND intersect that from collections with the
> tutorials that are featured as must see... that's too much! isn't it?
> 
> When they all belonged in the same cat system, the query gets much
> faster/efficient. True?