Prestashop, slow or not responding 3500 Categories, need help

[LarsTheWebDude]

Hey all, we are working on getting our shop online, and have hit a roadblock.

After adding our car database, about 3500 Categories, In Admin when you want to do something to a product or list a product, its so slow or times out..

Its the Categories that slowing everything down
Seems prestashop don't work well with many categories.
Also annoying that it expand the categories everything you look at a product.

 

What we did to try and solve this..

We upgrade shop from 1.7.5.1 to newest 1.7.6.1

We trimmed our car database down as much as we can.

We upgraded our hosting 3 times, and are now on the biggest one "Business" with one.com, this helped a little, no timeout any more, but surely 30 seconds to 1 minute to load a product in admin ;/

 

Can anyone help us change some code or something to solve this issue here please ??

[MichaelEZ]

i woud start with turning on profiling, then u shoud be able to see where problem is, atleast it will guid u to it 

https://sumselkawumsel.de/prestashop-1-7-how-to-enable-the-profiling-information-to-check-load-times/

[El Patron]

please also see/create issue here

https://github.com/PrestaShop

when searching for ps issue, focus search on github

[LarsTheWebDude]

Thanks, ive searched the net already, and searched grithub now also.
We are 2 persons that spend all yesterday, and all of today, looking, trying, searching, nothing..

We tested more: We made hosting, on 3 hosts, tested categories, as soon as we add our 3500 ish categories, it will be so slow or nearly dies..
Want to see a product, loading the long category list, then takes 15 to 30 seconds, if it does not time out, you will also get a Firefox script warning, and be told to wait or stop it. classic script issue. does not matter if you use chrome browser.

All 3 servers we have tested are the same pretty much.
All of them was the bigger hosting settings, like business, pro, premium and so on..

There for sure is a issue with categories in presta 1.7

I also don't understand why would you load them all, and expand them right away..
Seems Presta 1.6 was handling this all in a better way, and also had a window space for them where you needed not to scoll side to side... (side to side scrolling was banned in 1980'dies lol)

 

CAN ANYONE IN HERE HELP?
Program solution out of this issue, we will pay for your time.

thanks

Lars

[tuk66]

Many deeply nested categories mean many database queries to get the tree. There is only one solution - cache, cache, cache. The more the better.

[LarsTheWebDude]

Thanks for the feedback,  to chasche it seems there needs to be installed something on the server..
Memcached via PHP::Memcached
Memcached via PHP::Memcache
APC
Xcache

We are on a hosted solution on ONE.COM, don't have access to the server..
Any other way to use chasing? that works on a hosted solution?

 

[tuk66]

If you have more than usual requirements (many categories, many products, huge traffic), you should consider to host your shop on appropriate hosting (plan). There is no better way how to run a shop smoothly.

For example, CloudWays https://cloudways.com offers APC as well as Memcache.

[LarsTheWebDude]

Thanks for at advice, we have changed to a different system, no longer on presta..