I see. This would usually indicate that the database structure is optimized okay, though if your site is receiving a lot of accesses during that time it could impact it still (though again, 25-30 seconds is far beyond just 'slow' or 'a little bogged down' in my opinion).
Do you have any idea on when this tends to happen? Certain times of the day, for example? Weekends vs. Weekdays?
Also, have you tried switching to an IP for your connections and seeing if that makes a difference?
- Jeff @ DreamHost
- DH Discussion Forum Admin