Guest Posted February 19, 2004 Posted February 19, 2004 We had OSC running on a slower machine and we just migrated to one with about double the specs but now the site is running painfully slow. The catalog itself is ok, its just slower than it should be because the client cant grasp the concept of optimizing images. However, the admin system in almost unusable. Especially in the product attributes where I had to increase the PHP timeout to 3 minutes just to get the page to load. Windows 2003 Std Edition MySQL 4.01 1.7ghz CPU 512mb RAM PHP configured as ISAPI module Task manger shows typically 15-20% CPU load and there is plenty of available RAM. I have tried several tweaks to mySQL with no improvement. My client is really getting steamed now and I am at a real lose as to how to improve the performance.
Guest Posted February 20, 2004 Posted February 20, 2004 This is exceptionally frustrating. I have read every tip and trip, mySQL indexing, you name it and the admin system is unbearably slow. I could really use any suggestions at all.
Guest Posted February 20, 2004 Posted February 20, 2004 We discovered something VERY ODD tonight. If we are on the server itself, the site runs wicked fast but accessing it remotely is stupid slow. This is very evident in the admin section where there are almost no graphics to speak of. Now I am even more confused since the site is running so fast locally, but dog slow off the server.
Guest Posted February 20, 2004 Posted February 20, 2004 We discovered something VERY ODD tonight. If we are on the server itself, the site runs wicked fast but accessing it remotely is stupid slow. This is very evident in the admin section where there are almost no graphics to speak of. Now I am even more confused since the site is running so fast locally, but dog slow off the server. On your old box did you run OSC with Windows 2003 Server? 2003 is closed down in terms of security and that might be part of your problem. I am running on a 2003 box with more then 8 physical network adapters without any problem what so ever. Are you running PHP as cgi or isapi? The thing is I have encountered the same thing but the other way around, when sitting at the server OCS was "stupid slow" but wicked fast remotely. That turned out to be network settings (tcp, dns, etc). Please check your settings (osc, network) so there are no loop backs etc. Test to ping ip, ping host-name both local and remote measure the time and hopefully you will see some things there. Good luck! /Fred
Guest Posted February 20, 2004 Posted February 20, 2004 The old server was Windows 2000 and it ran ok. This is really getting to me now. We have a dozen other sites that use PHP and mySQL and they are super fast but the one site with OSC is very slow. I am running PHP as ISAPI since I wasnt making any progress with performance as CGI. What do you recommend? I will go through and double check all of the network settings as well. When setting up the connection to the local mySQL server, do you refer to it as 127.0.0.1, LocalHost, IP or hostname?
Guest Posted February 20, 2004 Posted February 20, 2004 I finally fixed it. The problem was running PHP as ISAPI. Once i switched it to CGI and tweaked the php.ini file, the site came alive. I find it a bit odd that the other non-OSC sites ran great with ISAPI and that OSC ran great locally only. Now the site is plenty fast. Thanks for all the help.
Guest Posted February 21, 2004 Posted February 21, 2004 Hello Kerry, i have the same problem. Can you please explain me ho to switch form Php from Isapi to CGI and how to tweake the php.ini? Thank you in advance for you help, Andreas Hasler www.tepperwein-collection.it
user99999999 Posted February 21, 2004 Posted February 21, 2004 Windows 2003 Std Edition <- Wonder why???????? ISAPI should work fine.
Guest Posted February 24, 2004 Posted February 24, 2004 Windows 2003 Std Edition <- Wonder why???????? Whats wrong with that? Its not Web Edition. Secondly, it is only a problem with OSC as several other large PHP apps worked just fine. To use CGI instead of ISAPI you have to change the reference from PHPISAPI.DLL to PHP.exe. Then, in the php.ini file are some IIS specific settings.
Genius Posted March 23, 2004 Posted March 23, 2004 Hi Kerry, I am having similar problems in my admin section when loading up the categories page in the admin section it loads pretty slow as suppose to the catalog site. Your Quote To use CGI instead of ISAPI you have to change the reference from PHPISAPI.DLL to PHP.exe. Then, in the php.ini file are some IIS specific settings. I am not too sure how to make these changes... I am using phpMyadmin on a shared server and don't really have access to the configuration on the database setting.. though i can edit file and upload them.. I don't know what to ammend and where to put the php.ini file on my web space. I am on linux server.. you help would be really great.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.