I had over 10K categories and posts on my WP site. Posts are created but don't have any content. I am hosting the site on mid-tier option for WP sites on Siteground.
Due to a large number of categories, my sites barely loads. Not sure if I am allowed to post a link to it.
According to Query Monitor, it takes 27 seconds to load the site. I am suspecting it is because of number of categories.
Is there anything I can do to improve the performance of the site? Maybe modify the way categories are pulled?