I would like to understand the performance implications of having a wordpress blog with lots of pages. I have my blog setup this way where there are 3 top level pages, and each top level page has about 700 sub pages each underneath (so about 2000 pages). I am looking at increasing this by a significant amount, looking at having maybe something like 4000-5000 pages or more in the near future.
I want to know whether WordPress would be able to handle that kind of load. Would it slow down to a crawl or can I expect reasonable performance with those page count numbers? I have been facing occasional problems with my shared domain hosting with SQL timeouts already (relieved a bit by SQL table optimize and wp cache plugin install).
If this is a problem, would converting pages to post help? For example, if the old page had a URL like:
where "event" is a parent page
and I change from this page structure to a post structure also having same URL.
where "event" is a category, and %category% starts the permalink
can I expect any performance improvements, or will it still remain similar to the performance of the page based system.