For a WP install we created a custom taxonomy which is used within a custom post type. This all seemed to work fine.
The problem started since this custom taxonomy needs to be filled with approximately 20000 areas (hierarchical). We imported them succesfully but now the custom taxonomy overview page and the custom post type edit page, which uses the custom taxonomy as category are both extermely slow (14 sec to load).
This probably has something to do with the loading of these amounts of categories. When the custom taxonomy category is empty or loaded with for example 10 categories the issue is gone.
When using the plugin Query monitor the total query time is 0,089 sec. So the problem doesn't seem to have something to do with the query times.
We are not sure where to start when debugging this so first of all 2 questions:
- is there a known maximum of categories to be used?
- What could be causing this huge slowdown in page loading if the problem isn't the query itself?