Oscommerce MySQL Database Optimization

We use oscommerce to build our store RuthiesMusic.com. Currently, we have about 10,000 products. Typically, it loads in about 20 seconds. Overnight, our site takes about 3 minutes to load. We havent changed a thing. 3 hours with our hosting service and they say it is too many products for oscommerce to handle. We have talked with other oscommerce users and tried all their tips and tricks as they say they have well over 20, 30,000 products with no problem. Cant figure out what happened while we slept overnight. So, we are ready to pay for a quick fix to our immediate problem and a step by step instruction on backing up and restoring our oscommerce database. We can not use the built in backup/restore feature with oscommerce as it times out before it is finished saving. Website in need of help - [login to view URL] Another website we have built on the same server - [login to view URL] has no problems. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Linux MySQL PHPMYADMIN Oscommerce