OSCommerce active store. For last 2 weeks the initial page load has been getting slower and slower. No add-ons or plugins have been installed in this time - more products have been added to the store though.
I attempted to 'index the database' but not sure I did it correctly. Did not speed anything up.
Upon first page load (20 seconds), all other pages load in 2 seconds. Total page size is under 200kb, so it is timing out or slowing down on something. If a user is inactive for 30 mins or so, the initial pageload will take around 20 seconds again.
Need this problem fixed ASAP.