I've gone from 0 to just over 2000 posts on my site in just under two months. My initial render time was about 0.10 seconds and it's now over 2.0 seconds. This is worrying and I need to understand more about why performance is degrading so quickly.
The way I understand "the loop", WP is pulling the 10 most recent posts, then stopping and displaying a page with a navigation menu. (I'm using Scriptygoddess' WP Paginate plugin for the nav menu. It displays the total number of pages, which I assumes it calculates from a table's row count.)
If that's how the loop works, then why would it make any difference to render time how many records there are?
I know there are caching plugins, etc., that can help here. At the moment, though, I just want to understand what the problem is. I'm hoping to build this database at a rate of 15,000 entries a year, but I'm not a programmer and don't want to have to hack my way to acceptable performance. Should I be looking at a different platform (e.g., Drupal or some other "enterprise" CMS)? Can WP manage a database of that size efficiently?
I'd appreciate any thoughts or advice.