What's the deal with Deno? We talk with a major contributor to find out. Listen now.

Questions tagged [performance]

Denotes questions related to performance on Magento

123 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
12
votes
1answer
1k views

Product List Attribute Filter Query

I have added one filter in Method _getProductCollection() of the class Mage_Catalog_Block_Product_List as follows. protected function _getProductCollection() { ... $this->...
11
votes
1answer
1k views

Magento2: Conditionally replace block template and class the right way

This rather trivial requirement turns out be quite a pain for us in recent days, as we couldn't find a satisfying existing solution, yet. The Task We are trying to replace certain blocks with a ...
8
votes
2answers
1k views

SQL query kills entire server

I caught the following query via mysql's SHOW FULL PROCESSLIST; which was eating the whole CPU / RAM on my server (32GB Ram, i7 hexacore CPU) rendering the entire server unusable for more than 3 hours....
5
votes
0answers
130 views

Add to cart not working in Magento 2.2.5 performance testing script “benchmark_2015.jmx” for customer account

In Magento2 - I am using Magento benchmark script "benchmark_2015.jmx" for a default Magento(v2.2.5) installation. In Customer Checkout thread group >> "Add to cart" request(http://prntscr.com/mty00o)...
4
votes
1answer
79 views

How to choose right caching technique for Magento2 and how to configure them properly

We are working on a new store and want the site to have cached. I think there are a lot of caching techniques but I would like to which are to be chosen. Ex: Varnish, OPcache, Memcache, Redis. ...
4
votes
0answers
401 views

Magento 2 - Page Speed Insights / Lighthouse Audits Low Scores

I noticed recently the Google page speed insights has improved somewhat, shows a lot more information however is harsh especially it seems for Magento 2 (I can get 98 so far from other non Magento 2 ...
4
votes
1answer
697 views

slow INSERT query in sales_flat_order_grid

We see in newrelic some peaks if orders are inserted into sales_flat_order_grid. I tried to figure out why, but couldn't find the reason. This peaks appear ~ 1 of 100 orders. First of all I thought ...
3
votes
0answers
51 views

EAV Model Product - Loading too heavy

Our website's using Magento 2 platform. Number of product and number of product's attributes keep growing faster.It leads to heavy loading when getting product's information(using EAV Model).In ...
3
votes
0answers
189 views

Why Mage_CatalogIndex_Model_Aggregation is not caching layered navigation filters?

A question for an expert. Make sure you read the preamble - the question is at the bottom. In app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php I noticed a functionality to cache ...
3
votes
1answer
751 views

RequireJS components sometimes not loading

We are launching a Magento 2.1.3 site, and finding that the site will sometimes load all of its Javascript components and dependencies properly, but sometimes fails to load, in which case a slider is ...
3
votes
0answers
495 views

Magento 2: Setting cron job for changing order status, can affect on performance?

I want to set cron job for order confirm. Below controller code Confirm.php used for confirm order from my fronted custom module. This will Set order status confirm. This is working fine. <?php ...
3
votes
0answers
413 views

Magento2 performance testing error

When I run the first time: magento setup:perf:generate-fixtures /var/www/setup/performance-toolkit/profiles/ce/small.xml I got this error: Generating simple products... Error in data structure: ...
2
votes
2answers
172 views

Why is the loading of scripts via RequireJS incredibly slow when they are not cached?

First of all, this is not a question about general Magento 2 performance. I'm already aware of how to speed up Magento 2, in general. My question is specifically about RequireJS and the assets served ...
2
votes
1answer
91 views

How do i decide a value for MAGE_INDEXER_THREADS_COUNT?

Can anyone suggest to me how to decide a value for MAGE_INDEXER_THREADS_COUNT? I am managing a website that has 5 websites, 10 stores, 6 customer groups. I know adding this environment variable can ...
2
votes
1answer
42 views

Page loads take around 10 minutes due to requirejs

I have a local site running Magento 2 Enterprise set up on a Hyper-V virtual machine running Ubuntu 18.04 and Nginx. I've got 4 CPUs and plenty of RAM assigned to the virtual machine. This same site ...
2
votes
2answers
64 views

Magento performance went dow by 50% after upgrading from 2.1 to 2.2

I've upgraded Magento 2.1.11 to Magento 2.2.6 and after the upgrade the CPU utilization and CPU load duplicated. Is was a simple and straight forward upgrade. No server changes were made regarding ...
2
votes
1answer
174 views

SQLSTATE[HY000] [2006] MySQL server has gone away - hosting company says to OPTIMIZE Magento :-(

Magento 1.9.1 Porto theme VPS server: RAM: 6 GB RAM Storage: 150 GB SSD Bandwidth: 6TB 8 cores Our Hosting company is Hostforweb.com They did this migration from a datacenter in Chicago to New York ...
2
votes
0answers
23 views

Advice on most performant approach to get variables once per session

I need to pass deviceType and userState(IL, IN, IA, KS, etc) variables to GTM for marketing purporses and wondering what’s the best way to do it. To calculate deviceType I will use mobiledetect php ...
2
votes
1answer
3k views

Why Magento is using high CPU in AWS?

I'm having a problem that is occurring after the volume of concurrent users on my site has increased. I'm currently with almost 600 concurrent users and the server is using 100% CPU. To alleviate ...
2
votes
1answer
641 views

Magento 2 - 11k Products on 1 configurable product too much?

A few specs: Using magento 2.1 PHP 7.0.9 VPS has 48GB RAM 8x Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz I am setting up an online print shop, and have created a CSV of all of our 100k+ variations we ...
2
votes
0answers
934 views

Magento 2.1 and PHP 7.0.8 work extremely slow

I had Magento 2.0.4 instance running on vagrant machine: CentOS 6.5 PHP 7.0.1 MySQL 5.6.31 I've upgraded to 2.1 with composer but then when I tried to run php bin/magento setup:upgrade I get ...
2
votes
0answers
560 views

Product brand (attribute, category or both)?

I am fairly new to Magento module development, and I am dealing with catalog/product pages at the moment. I have seen our clients using different approaches when dealing with storing product brands. ...
2
votes
0answers
257 views

Redis default configuration and utilization

We did install Redis server 3.0.7 which has made our Magento store 1.9.x a bit better than before, but I just need to ask that all settings which comes out of the box in Redis is fine? or do I need to ...
2
votes
0answers
345 views

Slow performance of: Mage_Eav_Model_Entity_Abstract::getSortedAttributes

Hi we are seeing some slow performance in "Mage_Eav_Model_Entity_Abstract::getSortedAttributes" I was reading this (from 2 years ago and Mage 1.6). Would this still apply? http://blog.nexcess.net/...
1
vote
0answers
6 views

Magento 1: change setting Display out of stock products to NO & effect on performance of indexers and db

Question: how much effect does disabling the setting Display out of stock products to NO in Stock options have? Does it improve indexer speed? Does it improve layered navigation building? Does it ...
1
vote
0answers
21 views

Overriding core user data files for Magepack

We are working on getting Magepack installed on our dev environment. One of the shims we had to fix was in the "customer-data.js". It works when we edit the core file(vendor/magento/module-...
1
vote
0answers
16 views

SearchCriteria vs Collection - Query Performance Difference

I am trying to refactor get category data method. Initially, it was written with Collection filter. Later I refactored with the search builder interface. When I tried to compare the querying time, I ...
1
vote
0answers
12 views

Load times for files in pub/static/ are extremely variable and often painfully slow

On Magento 2.3.3 I'm seeing extremely variable load times for files served from Magento's pub/static directory. This happens in both developer and production modes, and I can't understand what's ...
1
vote
0answers
33 views

\StoreResolverInterface->getCurrentStoreId() taking huge amount of time to resolve current store ID in StoreManager.php

Running Magento 2.3.4 and encountering an issue with Magento core code. For the past couple of days I've been battling terrible performance on my site, especially when serving uncached content via ...
1
vote
0answers
25 views

How can we redirect Admin Catalog Search to use Elasticsearch?

We have over 2M products in our catalog and growing. This has made the Admin Catalog Search completely non-functional (it spins until it times out). How can we update this to also use elasticsearch? ...
1
vote
0answers
46 views

Magento2.3: How to put a loader?

My website is taking too much time to load. When the site is loading, there are chances that the customer to click on the things which is not active yet. So I want to put a loader before the site is ...
1
vote
1answer
87 views

getIdentities spends a lot of time

We have very slow product detail pages. In a blackfire trace I see, that a lot of time is spent in getIdentities. Did anybody see this before? If I return []; in \Magento\Catalog\Block\Product\...
1
vote
0answers
66 views

Magento Commerce Cloud : Tool for real time monitoring of sql queries and processes

I need to monitor the number of SQL queries and processes and their corresponding CPU and swap usages in real-time just like the monitoring tool provided with PHPMyAdmin. I need something similar for ...
1
vote
1answer
2k views

How do i remove unused css from magento 2 homepage?

I am not getting good performance when i audit my website with chroome lighthouse. I am getting few errors like - Remove unused CSS - Ensure Text Remain Visible during web front load - Minimize main ...
1
vote
0answers
137 views

Magneto 2: How to configure a rest api only server for best performance?

I know magento have some recommendations for the best performance. And I found several articles related. But nothing specific for servers that provide access only by the Rest API. Because everyone ...
1
vote
0answers
26 views

Closure Compiler support

It seems there are several performance extensions for Magento 2 but none of them mention Closure Compiler which still yields the best results compared to the current minifier. The extensions which I ...
1
vote
0answers
106 views

htaccess for brotli does not work

I want to add the following code to my htaccess but it does not work. # ---------------------------------------------------------------------- # | Brotli pre-compressed content ...
1
vote
1answer
78 views

Magento 2 optimisation : SQL Seem's ok but its slow

I have a performance issue with my magento 2 store. I am using varnish, wish I believe works fine. Each not cached page take ~~ 3.5 sec up to 5 sec. (category page, home, product) Here is my ...
1
vote
0answers
61 views

Magento 2 - CMS Specific page_layout XML and Dedicated page_layouts in general?

I'm looking for some BEST PRACTICES insight into using page_layout.xml. Is it a good idea to try and decouple the non-shared resources on Product Pages, Category Pages and CMS Pages? If so, what's the ...
1
vote
0answers
112 views

Magento 2.2 - Want to implement blackfire for community edition

I have heard about blackfire php profiler and automated performance tool that can be used in three environments. If i wanted to implement in Magento 2.2 based website using nginx server then is it ...
1
vote
0answers
52 views

Redirection Error

We built a website with Magento 2x version. We are monitoring our web server performance using Pingdom. Today, we got an alert message from Pingdom and it says the server is down for around 20 minutes....
1
vote
0answers
14 views

How to check if an external process may be causing slowness while going through placing an order?

Magento 1.9.1 Porto theme We had perfomance problems with the hosting company. They migrated us to their best VPS machine/node and now things seem to run rather fast except for when going through the ...
1
vote
0answers
46 views

Cron jobs interfering with load testing

I'm load testing a Magento site using Gatling. The site is hosted on 4 Amazon EC2 machines behind an application load balancer. If all of my cron jobs are disabled, the site can take a good amount of ...
1
vote
0answers
727 views

Ideal EC2 Instance type for magento 2.2.3

I am running the magento 2.2.3 version on AWS EC2 currently on c5x.large the performance seems fine for me with proper page speed backed by cloudfront and Redis. Due to cost optimization I have ...
1
vote
0answers
56 views

Profiler: every page load produces twice entries in aoe profiler runs grid. Is frontend “executed” twice?

I'm currently doing some bottleneck hunting on my M1. I've installed AOE Profiler. I do some test on category page. In the backend (System > AOE Profiler) I noticed there is twice entries at every ...
1
vote
0answers
65 views

How to understand magento 2 profiler output?

I've just enabled profiler on my M2 site (csvfile output). But I can't understand its content. Is there any software that could make the output data more understandable?
1
vote
0answers
79 views

Magento Performance using image Optimization tool

My current Magento EE1.14 website is loading around 9 seconds with enabling Varnish Cache, Merging JS and CSS, Having Nginx web server, enabling Zend Opcache, running page warm up scripts, enabled ...
1
vote
1answer
1k views

Time To First Byte with varnish cache - 12 seconds

I installed varnish cache and verified using official guide. In official guide mention 5ms to load the url with varnish but mine it is 12s. Info: OS : ubuntu 14.0.4, webserver : apache2, php : 7, ...
1
vote
1answer
65 views

Magento increase CPU system usage after 1.7.0.2 update to 1.9.3.3

After I updated Magento, it starts to use more CPU than usual as you can see below. After 05-07, CPU system time increases, just at the day I updated Magento to 1.9.3.3. In this second image you can ...
1
vote
0answers
1k views

Magento 2 Import Performance

For Magento 1 there is an informative report about the import performance in https://www.integer-net.de/produktimport-mit-magento/ For Magento 2 and a shop project with < 10 k simple products we ...