How "sudden" was the change?
Could it be that the server is doing backups at this hour ? That will slow things down somewhat while databases and files are archived for safekeeping ... whether related to your specific site's data or not.
Other common causes of data-intensive pages slowing down drastically could be that indexes on database tables are broken or busted. In case you're thinking of asking "how do I fix that" ... that's a manual process, and to investigate you'll need to understand table structures and how each table's indexes are supposed to be built. If you have an understanding of SQL, you can find the master list in the mysql_zencart.sql file in the zc_install folders.
I suspect your problem is with something that's hogging the server's resources ... or has mis-allocated server resources such that there is insufficient disk space or RAM available to the database, thus hindering it from doing what it needs to do.
Sorry, that's a lot more technical than I think you need.
Your hosting company knows your server. They're the experts who need to respond to the problem.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
