Performance

Auto Added by WPeMatico

Filter by attribute is slow for customer collection using addAttributeToFilter() function

by magento man

I have created a custom attribute called username for Customer which is searchable in admin grid. But whenever I search by username for SSO it takes much time (2-3 sec). Below are the code: $objectManager = MagentoFrameworkAppObjectManager::getInstance(); $customerObj = $objectManager->create(‘MagentoCustomerModelResourceModelCustomerCollection’);… Read More »Filter by attribute is slow for customer collection using addAttributeToFilter() function

Is there a proper way in magento to use stored procedure?

by magento man

Is it possible for replacing the default product collection from model/resourcemodel with some stored procedure having some dynamic query which use different product ids as parameter based on current category on listing pages ? Theoretically Stored procedures are known to… Read More »Is there a proper way in magento to use stored procedure?

CPU 100% most of the time – maybe a cron problem?

by magento man

e are running shop on Magento 2.4.3-p1 with 50 000 SKUS, about 800 categories and 5 language mutations. About 65000 users and 80 000 sessions monthly. We are using cloudways server: 32GB RAM 8 core processor 640 GB storage The… Read More »CPU 100% most of the time – maybe a cron problem?

Most Reliable Hosting Company Sites in July 2022

by magento man

Rank Performance Graph OS Outagehh:mm:ss FailedReq% DNS Connect Firstbyte Total 1 Aruba Linux 0:00:00 0.000 0.369 0.007 0.028 0.099 2 Rackspace Linux 0:00:00 0.000 0.486 0.010 0.021 0.022 3 New York Internet (NYI) FreeBSD 0:00:00 0.000 0.564 0.075 0.150 0.150… Read More »Most Reliable Hosting Company Sites in July 2022

Fastest way to get attribute value of custom product attribute by attribute_code and sku

by magento man

Hello fellow Magento developers, What is the most efficient way of getting an attribute value of a custom eav product attribute, by only using its attribute_code and the products sku? => The question mainly targets the most efficient way, but… Read More »Fastest way to get attribute value of custom product attribute by attribute_code and sku

Magento 2: performance issue with MagentoFrameworkViewTemplateEnginePhp::render

by magento man

I have enabled the new relic log to check the performance of the Magento 2 website. On home page I am rendering 5 blocks with 5 template files. In new relic logs, it shows homepage takes time to render MagentoFrameworkViewTemplateEnginePhp::render… Read More »Magento 2: performance issue with MagentoFrameworkViewTemplateEnginePhp::render

Most Reliable Hosting Company Sites in June 2022

by magento man

Rank Performance Graph OS Outagehh:mm:ss FailedReq% DNS Connect Firstbyte Total 1 Aruba unknown 0:00:00 0.000 0.360 0.005 0.025 0.086 2 Rackspace Linux 0:00:00 0.000 0.472 0.013 0.028 0.028 3 New York Internet (NYI) FreeBSD 0:00:00 0.000 0.534 0.075 0.150 0.150… Read More »Most Reliable Hosting Company Sites in June 2022

What methods do you use to optimize the work and performance of the backend part (.php)?

by magento man

I want to try to optimize the performance of Magento 2. After searching this question, I see that for the most part everyone removes modules that are not used on the project or that are obsolete. But I want to… Read More »What methods do you use to optimize the work and performance of the backend part (.php)?

Most Reliable Magento Hosting Sites 2022

by magento man

Rank Performance Graph OS Outage hh:mm:ss Failed Req% DNS Connect First byte Total 1 Kubeservers Linux 0:00:00 0.000 0.466 0.010 0.022 0.023 2 krystal.uk Linux 0:00:00 0.000 0.185 0.070 0.138 0.138 3 New York Internet (NYI) FreeBSD 0:00:00 0.000 0.541… Read More »Most Reliable Magento Hosting Sites 2022

Most Reliable Hosting Company Sites in March 2022

by magento man

Rank Performance Graph OS Outagehh:mm:ss FailedReq% DNS Connect Firstbyte Total 1 Aruba Linux 0:00:00 0.000 0.356 0.007 0.029 0.031 2 Rackspace Linux 0:00:00 0.000 0.513 0.009 0.019 0.019 3 Hyve Managed Hosting Linux 0:00:00 0.000 0.140 0.069 0.138 0.138 4… Read More »Most Reliable Hosting Company Sites in March 2022