Hmm... I need to find out myself. I don't know what is the right answer. I'll do some Googling and get back to you if I discover an good answer. You should email the people at iPage as they probably could help you..
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..
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?..
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.
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....
That may help some.....
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 iPage 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..
This post has been edited by.
: 22 June 2004, 01:31..
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 iPage site is now on www.saiccorp.com/catalog.
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...