I have a wordpress site on a hosted linode that the purpose is to be a directory of sorts. I have 9300 categories (55 main categories, each with about 10 sub categories, with each sub category with ~15 categories).
These are also not just categories, but a custom taxonomy instead.
I'm having a lot of slowness issues with the admin section JUST in the area related to loading the taxonomy (editing posts using that taxonomy, or adding/removing categories from that taxonomy).
I've looked into mysql adjustments and php enchancements but I'm wondering if there's a proper way to optimize wordpress to support LARGE category numbers. And converting to tags will not work, the tags serve an additional purpose in our directory. Thanks!