Guest Posted June 21, 2004 Posted June 21, 2004 I'm Starting to use oscommerce for a company that will hold up to 9000 items in about 1500 categories and sub categories. But when I start to add them to de DB is getting slower and slower and I only have 600 items in for now. Could be this amount of items too mouch for oscommerce? I try with cache, persistent connections on and off (do not know exactly if it would help), reducing the number of categories to 800 but nothing is improving it. I appreciate if some one could give some advice on that or where can I look for some tips the site is now on www.saiccorp.com/catalog thanks cesar
vasttech Posted June 22, 2004 Posted June 22, 2004 Sounds like an issue with your host. Search the forums as there have been a couple discussions recently about db performance and hosts. Your host most likely has 100s of sites running on the server. osCommerce Knowledge Base osCommerce Documentation Contributions
Guest Posted June 22, 2004 Posted June 22, 2004 thanks for your answer how can I be sure if it is a host problem is there a way or a test that I can run to see if it is the case :huh:
lostxpinoy Posted June 22, 2004 Posted June 22, 2004 I think I may be experiencing the same problems that you are. What are the specs for the server you are on? Is it shared or a VPS?
Guest Posted June 22, 2004 Posted June 22, 2004 in your configure.php files you need to edit out the // and make it / do this by taking off the / at the end of your URL in the configure.php files in includes/configure.php and admin/includes/configure.php You can see what I'm talking about if you hover the mouse over a link in the category box and look at the link at the bottom of the browser... Mike That may help some...
Daemonj Posted June 22, 2004 Posted June 22, 2004 Ensure that Show Category Counts is false in Admin ~ Configuration ~ My Store. You will definitely want to use persistant connections both for MySQL and Apache. If you are running MySQL 4 you should enable query caching. (Search the tips and tricks forum for topics by me). Definitely add some indexes to the database to improve query performance. (Search the tips and tricks forum for topics by me). You can contact your host's support department and inquire how many sites are running on the server that your site is on and they should tell you an exact number. If they are not willing then the server is definitely overloaded and they know it and you might want to consider going to a better host. "Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein
Recommended Posts
Archived
This topic is now archived and is closed to further replies.