I've been using WP since last November. I've got 1.5 installed now and have recently been getting the dreaded "too many connections" problem. My users see the WordPress "Error establishing a database connection" error and I discovered from my host that I get 15 connections to the db at a time. I guess I'm getting a lot of hits (or 'bots) because this happens for hours at a time, usually in the middle of the day, when people hit my site the most. I've talked to my host about upping my limit but they say they can't do it unless I get a dedicated server, which they don't offer.
I have been with my host for half-a-decade and really don't want to gamble with finding another one--is there anyway to have a flat file alternative for my users? Like maybe a plugin that would make flat file versions of your most popular posts to easy the pressure on the db? I'm also wondering if anyone knows of a good and inexpensive host I might switch to that would have a much higher limit to the number of db connections.
If anyone has any other possible solutions, I'd love to hear them. I've grown very accustommed to WordPress and don't want to have to switch back to GreyMatter (cringe!).
Thanks in advance!