Magento 2 Admin Dashboard became very slow since last 10 days

[omkar_mhetar]

Magento 2 backend became very slow. It is taking at least 1 min to load every page. I have checked all log files also but no issue found. After that, I create a custom log file to check data when response time more than 7 seconds. In that I have found below data :

[0x00007f9aaa616ba0] execute() ......vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
[0x00007f9aaa616ae0] _execute() ......../vendor/magento/framework/DB/Statement/Pdo/Mysql.php:95
[0x00007f9aaa616a30] _execute() .........../vendor/magento/zendframework1/library/Zend/Db/Statement.php:303
[0x00007f9aaa616970] execute() .........../vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:480
[0x00007f9aaa6168c0] query() ........../vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:238
[0x00007f9aaa6167d0] query() ............./vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:465
[0x00007f9aaa6166c0] _query() ............/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php:520
[0x00007f9aaa616610] query() ............./vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php:737
[0x00007f9aaa616540] fetchAll() ........./vendor/magento/module-catalog/Model/ResourceModel/Product/Gallery.php:119
[0x00007f9aaa616480] loadProductGalleryByAttributeId() .........../vendor/magento/module-catalog/Model/Product/Gallery/ReadHandler.php:56
[0x00007f9aaa6163a0] execute() ........./vendor/magento/framework/Interception/Interceptor.php:146
[0x00007f9aaa616230] ___callPlugins() ........../var/generation/Magento/Catalog/Model/Product/Gallery/ReadHandler/Interceptor.php:26
[0x00007f9aaa616180] execute() ............./vendor/magento/framework/EntityManager/Operation/Read/ReadExtensions.php:48
[0x00007f9aaa6160a0] execute() ............/vendor/magento/framework/EntityManager/Operation/Read.php:117
[0x00007f9aaa615fb0] execute() ................/vendor/magento/framework/EntityManager/EntityManager.php:61
[0x00007f9aaa615ed0] load() ................/vendor/magento/module-catalog/Model/ResourceModel/Product.php:655
[0x00007f9aaa615e20] load() ............/vendor/magento/framework/Model/AbstractModel.php:531

This all files are common for every page load and some files from marketplace extension.

[Surbhiagr]

Hello @omkar_mhetar ,

You can use following techniques to speed up your admin panel. 

1.  Switch to **production mode**.

If you need to stay in developer mode then here are 3 tips:

2. Disable CSS & JS merge / bundle / minify**. You can do so at *Stores > Configuration > Advanced > Developer > Javascript Settings and CSS Settings*
3. Increase php memory limit from php.ini files.

You can also checkout this article which gives more ways to increase speed 

https://www.goivvy.com/blog/speed-up-magento

Hope it helps! Kudos and accept as solution if it works for you

[Surbhiagr]

Hello @omkar_mhetar ,

You can use following techniques to speed up your admin panel. 

1.  Switch to **production mode**.

If you need to stay in developer mode then here are 3 tips:

2. Disable CSS & JS merge / bundle / minify**. You can do so at *Stores > Configuration > Advanced > Developer > Javascript Settings and CSS Settings*
3. Increase php memory limit from php.ini files.

You can also checkout this article which gives more ways to increase speed 

https://www.goivvy.com/blog/speed-up-magento

Hope it helps! Kudos and accept as solution if it works for you

[Surbhiagr]

@omkar_mhetar , you can accept it as a solution if it worked for you, so  that other could also easily find the solution in case they encounter same problem