I would like to know the answer too. Anyone here know what is the answer to your question. I'll do some poking around and get back to you if I find an answer. You should email the people at iPage as they probably could give you an answer..
While I am sure that there are some limitations to performance in the osc code as well as the current version of mySQL and it's query language, the majority of your performance issues will come from the hardware you are running on. If you are running into serious performance issues with the more products you add, I would first look into what hardware I was running on. Especially if you are on a shared host, where you may be sharing that server with 100s of other sites. I have seen stores with 10000+ items that run extremely fast, and I have seen sites with 1000 items that run extremely slow...
Well I'm running a VPS at VPSColo and here are my server stats:.
Minimum Guaranteed RAM.
Minimum Guaranteed CPU.
2 X 2.4 Ghz (Dual Xeon).
VPSs per CPU.
Would these stats do okay? If not, can you give me some stats I should look for in the event I need to upgrade to a better server?..
Sizing hardware is a difficult question. While you should be fine with that config, it can all depend on how the other sites hosted on that server utilize resources and how the host has the VPS configured. Remember your host is going to try and get the most for their money out of each server. For example when they say <16 VPSs per CPU they probably mean =15 to 16. Catch what I am saying..
With that said. If you are not experiencing problems on the catalog side of things I would not think that it is a hardware issue though. Are you using SSL to access the admin area? If so try not to use SSL for admin as this can add extra overhead to the server..
There are ways to optimize mySQL, like setting indexes on tables and using query caching so that the server does not have to rerun each query if the results are going to be the same...
The first step is to check your parse times, it should be less then 1...
Lots of this also tie in with what you are doing in the admin area. if you have lots of attributes, this can be a killer. also, do you have access/control over your php.ini? sometimes, you may have what appear to be killer settings for the server, yet your php.ini setting may be set at 8 mb max_memory and the timeouts are set low. if you have access to the shell, you need to monitor the 'top' command. check your server access and error logs, see if there are abnormalities in there, especially the error log. I just finished one for a client last week, their error log was getting hit with one error per second due to misconfigurations on the host side of the system.
Lots more to consider when you are troubleshooting this type of problem...
I just checked my errors logs and I have this error appearing throughout my error logs:.
Chmod: changing permissions of `/home/anime/public_html//images/imagecache': Operation not permitted.
Any idea what the problem could be?.
I see the double slashes in there and I think that could be the problem, but where would I start to look to fix such a problem?.
Thanks for all the help so far. I'm going to implement all your suggestions as soon as possible..
This post has been edited by.
: 18 June 2004, 03:22..
I enabled the option to display page parse times and it showed it as being 5 seconds. My page has many images that it loads which you can view at:.
Would that be what's causing the problem or is it an inefficiency problem in mysql that I caused?..
5 secs is to long. This parse time is how long it takes for PHP/mySQL to generate the page. The time it takes for your browser to load the page and the images from the server is a different issue. Most likely mysql configuration or load. You can do some things like turn off category counts, add indexes, enable cache for cats/mfgs but I doubt you can get 5s down to 0.5s...
Still looking but I did want to tell you I found one error in one of your links under coming soon:.
07. Wolf's Rain DVD 1: Leader of the Pack.
When I click on the link I get a SQL error...
Also check your apache error log you might find some clues there...
Also, is your mySQL server on the same system as your web server? Some hosts will setup a seperate server just for mySQL. If this is the case you could experience delays due to the network...
MySQL and my web server are on the same machine. My category counts were disabled. When I enable caching, the category section of my layout gets misaligned..
What is this about indexing? Would it help tremendously? Also I found a contrib about faster page load times and less DB queries. Should I give it a shot?.
The only error I receive are the ones I posted on the page before about chmodding the imagecache directory or something like that...
Besides the extremely long parse times for my pages, did the iPage site load OK for you?..
You need to setup your folders properly in the admin section to match your document root folder paths for the cache which is defaulted to /tmp.
Before installing anything else I would fix this problem first..
Also 5 secs is tooooo long nothing you can do in PHP/mysql to fix that..
Contact your host and maybe they can fix it..
Search these forums for my.cnf and have your iPage hosting company check that out..
I'm going to look that thread you supplied about my.cnt and see what I can derive from it..
Mibble - what do you mean? I have standard root osc installation. How would I go about doing what you suggested?.
I'm going to get in touch with my host and see what they can do for me...
I just pushed well over 2000 products on my iPage site and have started experiencing slowdowns in my admin section. My catalog seems to be working fine though it feels a lil sluggish at times. Are there steps I can take to optimize the mysql processes without putting my iPage site in jeopardy or harming any contribs I installed?.
Is there a theoritical limit to how many products osCommerce can handle efficiently or is it the server and it's hardware that would be the limitation and not osCommerce?.
The reason I ask is because in the future, my store is going to be having thousands more product and I want to know if osCommerce can handle it well enough or should I look into an alternative solution..
Any help or info regarding this matter would be greatly appreciated!..
Turn on the parse time logging in admin and see what the results are...