Since upgrading to Magento 1.6 it appears as though our site has slowed significantly taking over 20 sec to load a category page. I know that Magento is not known for speed but the 126.96.36.199 install used to load a category page in around 6 sec, still slow but not nearly as slow as post 1.6 upgrade.
Our server hardware is more than capable;
Intel Xeon X3440 - Quad Core 2.53GHz, 8MB Cache, Intel VT
Hardware Raid 1 (Mirror)
cPanel for Linux
4 x 300GB SAS 15k
CentOS 5.x 64bit
12GB DDR3 - 1333 ECC
We are showing 50 products per page. After upgrading to 188.8.131.52 page load time increased to over 20sec with the same exact configuration.
I upgraded via ssh using pear to go from 184.108.40.206 to 220.127.116.11.
Actions i’ve taken so far to no avail…
- Performed a mysql DB check all tables returned OK.
- Compared DB to fresh install DB using Magento’s DB checker tool and it repaired some missing indexes in the core_url_rewrite table, I then truncated that table and ran the reindex to repopulate. Everything works, still slow though.
- Duplicated the entire DB and installed a fresh 18.104.22.168 install (with no modules, themes or anything) and set the local.xml to point to copied db, stock install still takes approx 20 sec to load category page.
Despite the above efforts and countless hours of forum trolling. Same performance issue exists.
Is this normal? 22.214.171.124 is just so much slower than 1.4? Surely it can’t be normal to take ~20sec for a stock magento install to load a category page.
We have just over 8,000 products in our system, approx 4,000 of which are visible on the front end. We do have quite a lot of attributes that users can navigate with on category pages.
Category pages with larger amounts of products take longer to load. Time to first byte on home page is around 1.8sec and on category pages is over 20 seconds with 1.6. On 1.4 time to first byte on a category page was approx 4 seconds and around 1.5 sec on homepage.
Caching is on, indexes are built and config is set to use flat tables. Is 1.6 handled differently to 1.4? Should i be tweaking php and mysql? We are running php 5.2.17, http://www.kinkyminx.com.au/phpinfo.php
Has anybody experienced this or have any suggestions at all?
Any help would be greatly appreciated.