Fix for slow category loads! > 서버관리 Tip

We were having awful performance all over our site. Our apache/mysql was optimized and then optimized again. We tried every php encoder out there with no luck. Things like product page and shopping cart pages were just slow. I’m talking around 3-4 load times.

If you got on the server apache would use 80-95% of cpu time to load a page. This was the big clue. That means there was a loop somewhere.. and a big one.

So i loaded up xdebug on our dev environment and here is the result. (see the attachment)

Now you will noticed that strpos was getting called over 6 million times. We have around 2500 categories and it was even being run on pages that the category list was not in place. One of the developers found it was due to category events being called over and over if there were no events attached? (sorry if i’m explaining that wrong.. i’m just the sys admin)

So here is how we fixed it.

Admin -> System -> Configuration -> Catalog -> Catalog Events

Then you want to turn off the following

Enable Catalog Events Functionality
Enable Catalog Event Widget

Once we did that we refreshed the cache and boom.. page loads were FAST!

Hope it helps