I'm having an issue when I try to bring up a sitemap on several of my sites. They all have the following in common: 1. All hosted on Godaddy 2. All running Wordpress 3. All have 3,000-4000 posts On these sites when I try to bring up the sitemap I very regularly get the following error message: "WordPress database error: [Lost connection to MySQL server during query]" This occurs after a long reponse time. On other sites I have the exact same setup, however there are only 200-500 posts. In those cases I don't get a MYSQL error. My question is what would cause this database error. Bad data? Bad Hosting? I'd appreciate any help. (below are 2 links. The first is to the page that regularily gives that error message. The second is to a page that does not give that error message.) http://www.data-entry-jobs.net/sitemap-data-entry-jobs (4000 posts) http://www.paid-surveys-free.com/sitemap-paid-surveys (250 posts).
Your answer is partly here: [1. All hosted on Godaddy] Godaddy is pretty crappy hosting. Don't know much about wordpress, but the query could be being dropped due to lack of resources - are the tables indexed properly - is the server responsive otherwise? Are you limiting the data returned on a per page basis, or is the query getting the whole lot? Lots of variables!