The admin catalog product overview does load very very very slow (15minutes+) or not at all.

The product overview in the admin loads pretty fast until the animated loading icon appears. So you see the page with the header and menu but no products yet. No 40x or 500 HTTP requests in Chrome or Firefox. The browser simply freezes. No right button response for example.

The server does not show any load when opening the page. Loads up to 0.1x.

After looking for hours and hours, reading and looking for solutions I am lost. Does someone have any idea?

Background information

  • Magento V2.2.6
  • PHP V7.0.27
  • My store has about 50k products and 2.5k categories.
  • Running on a decent dedicated server (64GB memory) at a specialized Magento hosting
  • The frontend and everything else in the admin loads pretty fast. Mostly page load times of 0.x seconds
  • Flat catalog and categories is ON
  • Minify JS & CSS is ON
  • Combining JS & CSS is OFF
  • Do you want to try with flat catalog & categories off? They don't really provide tangible speed increases in Magento 2 – Adam Mellen Jul 29 at 14:24
  • I'll try and update here when results are in. – Frank Heinen Jul 30 at 6:23
  • No effect at all. It has not become quicker or slower at all. – Frank Heinen Jul 30 at 8:00
  • You'll need to run some benchmarking then. Try asking your provider to check for slow logs, if there aren't any then look in to getting XHProf or similar installed on the server – Adam Mellen Jul 30 at 8:25
  • Thanks for the advise. Contacted the provider. I'll keep this ticket updated when more information is found. – Frank Heinen Jul 30 at 11:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.