PrestaShop 1.6 Change Category Tree functionality

[assault3r]

Hi at all, my first post

 

I'm using PrestaShop 1.6 and I'm setting up an e-commerce with more than 35,000 categories. After searching the forum and Google I have read many articles about the performance, and to have good performance would require at least a decent server that can support the whole. Ok

 

First of all, the problem I have found with all of these categories is, Catalog->Categories run too slow when opened (often crashes the browser) and after various tests, I get the Categories Tree's call generated (MySQL Query to gain Categories) is too big.

Same problem in the Associatives Tab to set Categories of a Product when trying to Add a New Product (when PS1.6 trying to generating the same tree).

 

Result of all:

 

Catalog->Categories (Too slow) 

Catalog->Products . Add New Product (Associatives Tab) does not open

 

This is a result of page test when loading it during excecution of MySQL Query for Category Tree:

 

Using RAM (KB)

101776 (101Mb)

 

Number of files read

481

 

I thought: changing the way we see the categories, that is, that rather than see them at once, the categories may be displayed for a depth level at a time

 

Example:

 

+ Root Category

   + Category1

   + Category2

 

By clicking on one of the two

 

+ Root Category

   + Category1

     + SubCategory1

     + SubCategory2, etc, ..

   + Category2

 

Graphically may look the same operation that is already there, but with the difference that the categories would be loaded dynamically depending on demand.

 

I accept tips, advice and news on how to behave in this regard, especially if is possible change the way of loading category in the backoffice like the way I suggest

 

Thank you in advance (sorry for my English)

[shacker]

ok, in preferences, performance, have you setted all for optimal performance? enable cache and cache filesystem, 

[assault3r]

Yes Sir, it's a BackOffice 'problem', not for the Front