search

Geta / geta-optimizely-categories

An alternative to Optimizely's default category functionality, where categories are instead stored as localizable IContent.
5 stars 10 forks source link

Performance issue #36

Open inmetatosu opened 4 months ago

inmetatosu commented 4 months ago

Hi,

If there is a large number of categories with multiple levels, performance is seriously affected when loading the category tree. Could you look into this?

Regards, Torunn

Eric-4NG commented 3 weeks ago

Same here, for every sub-category a XHR request is fired. Would be nice if it could be loaded with a single request, or paged? Less stress and the browser will handle it easier as well I assume.

alasvant commented 4 days ago

Same here, category has 70 children and occasionally it leads to situation that we don't get category picker correctly populated as some of the XHR requests will return 500 or 502 (DXP env CloudFlare). DXP log stream shows that database gives timeout.

Eric-4NG commented 4 days ago

After dirty work-arounds to load the items one request at a time, it still times out. Eventually we ended up here: https://support.optimizely.com/hc/en-us/articles/4432366206733-CMS-12-site-crash-due-to-SQL-timeout-error-when-working-in-CMS-edit-mode

After requesting what the recommended value is for this, Optimizely Support suggested to turn MARS off. So that is what we've currently done. But we still have to monitor the effects of this change. But you could give that a try as well.