Back office performance issue (and solution)

[Thomas Dedericks]

Hi !

Just solved a performance issue with the back office with a large catalog of products (~ 17.000), so I thought I should share.

The problem was the loading time of the catalog page. When you display the Home category, Prestashop counts every product in stock in every single category. This can be really slow if you have many products in many different categories. Since the total products' count in stock isn't a critical information in most cases, you can disable it easily by commenting line 41 in /admin/tabs/AdminCategories.php :

'description' => array('title' => $this->l('Description'), 'width' => 480, 'maxlength' => 90, 'orderby' => false),
//'physical_products_quantity' => array('title' => $this->l('In stock Products'), 'align' => 'center', 'width' => 50),[/b]
'active' => array('title' => $this->l('Displayed'), 'active' => 'status', 'align' => 'center', 'type' => 'bool', 'orderby' => false));

Those 2 slashes took the Home category page loading time down from 100+ seconds to 0.195s

[CYTechnologies]

very cool Thanks!

[Acceos]

Sorry for digging up an old thread.

I just wanted to say that this fix works in 1.2.5.0 aswell. Brought my loading time down from 38s seconds to 3s.

Thanks a lot Thomas Dedericks. ++++