Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 12-02-2009 07:03:49

RobH
Member
Registered: 02-12-2009
Posts: 117

performance issue with MySQL, IIS6 and CCP6

Hi guys,

My CCP6 was really quick when I was using MS SQL but since changing to MySQL (to resolve some issues) I find there is a 5 - 10 second delay when accessing the cart - when adding an item, viewing the cart, deleting an item from the cart etc. This can't be good for business.

I've set output_buffering = on in php.ini as this seems to have helped a lot of people with similar issues, hasn't improved things noticeably for me though (I have rebooted the server).

Accessing the cart from the server itself via Internet Explorer is extremely fast. The rest of my .html and .asp pages are served up very quickly as is phpinfo.php, it only seems to affect pages accessing the cart/MySQL. I have no known means of testing whether it's MySQL in general or specifically the cart,

Any ideas where I should be looking?

Thanks and regards,

Rob Hemsley

Offline

 

#2 12-02-2009 07:31:44

RobH
Member
Registered: 02-12-2009
Posts: 117

Re: performance issue with MySQL, IIS6 and CCP6

Ok, I've fixed it, first bit of good news I've had in a while!

Probably unique to my setup but out of interest I'd installed MySQL admin some time ago and have just reconfigured the instance settings to be more appropriate to my needs, works great now :-)

Cheers
H

Offline

 

Board footer