My organization's site in running EE 1.6.8 hosted on Rackspace Cloud Sites. In the last few weeks we have noticed that it takes longer and longer to update an entry in the control panel. We are now at approximately 20-30 seconds from the time we click "Update" to when we get the preview screen verifying the entry has been updated. Other aspects of the CP load quickly like opening entries or viewing entries in a particular category.
Strange thing is that we have a staging version of the site also hosted on Rackspace Cloud Sites that has its own database but it is just a copy of the live site and the stage site CP updates entries quickly - 2 seconds max.
The front end of both run okay as well. For some reason it just seems like the live site hangs when writing new info to the DB.
Here is the debug info from the bottom of the preview screen of an updated entry:
ExpressionEngine 1.6.8 - © Copyright 2003 - 2009 - EllisLab, Inc. Script executed in 0.4475 seconds 19 SQL queries used Build: 20090915
0.4475 seconds ? More like 25 seconds in real time.
If both sites have the same DB, site files, addons etc what are your guesses for the slowness?