Categories Question and slow queries

[karen]

Question about categories, recurring events and slow queries. Having just dug myself out of a problem with Slow queries on my website, I wondered about Categories and how they affect Events . The question is: Does the number of categories affect the length of queries and slow them down? I suppose I could reduce the number of Categories if I was armed with this info.
And can you tell me where I can find the names of the tables?
thanks!

[Gustavo Bordoni]

Hi Karen,

Thanks for reaching out to us.

First I would like to say that unless you are dealing more than 10.000 Categories/Tags I wouldn’t worry about this kind of optimization, there other ways to speed up the website by using caching, I’m talking advanced level caching not only plugin based.

So as you asked I will point you to first the Codex with the WordPress Schema and there you will be able to see a Table called <b.wp_terms, the idea is that any category is a Term and the group called “Categories” is a Taxonomy.

WordPress uses 3 tables manage that information:

I would only go to that place of micro optimization if you really know what you doing with PHP and WordPress development.

My Best Regards,

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts