Questions tagged [performance]
Denotes questions related to performance on Magento
460
questions
0
votes
2
answers
73
views
Slow saving products after upgrade to MariaDB 10.4 (Magento 2.4.5-P1 and PHP 8.1)
Since we upgraded Magento to 2.4.5-P1 and moved to MariaDB 10.4 (now 10.4.28) and PHP 8.1, we are facing really slow saving of products in admin. Everything else is fast, like the frontend, and ...
- 282
0
votes
2
answers
26
views
Share catalog is taking too much time to reindex
We have almost 900+ shared catalogs across multiple stores in one setup, the pricing is assigned to each product.
When we are doing reindexing. It is taking 3-4 hours to complete Catalog Product ...
- 12.4k
1
vote
2
answers
180
views
Performance issues after upgrade to Adobe Commerce 2.4.6
My Adobe Commerce was running fine, but after the upgrade, I can see via New Relic that it takes more time to process queries.
I tried to upgrade my MariaDB to versions 10.4 and 10.6.
Is there any ...
- 12.4k
0
votes
1
answer
46
views
What are some best practices for optimizing the front end performance of an Adobe Commerce store, with an emphasis on increasing lighthouse scores?
For someone looking to increase the front end speed and optimize the front end performance of an Adobe Commerce store, with an emphasis on lighthouse scores, what would be some good starting points to ...
- 2,169
1
vote
2
answers
82
views
how can we increase performance of bulk product save in magento 2 api
when we test performance of bulk product create api request using Apache 2 Benchmark, it takes to much time for return response of request.
I tested bulk api requests with 200 total number of requests ...
- 177
1
vote
2
answers
86
views
Adobe Magento Cloud how to add robots.txt
What are the best ways to add the robots.txt file to adobe magento cloud environment
- 568
2
votes
2
answers
38
views
magento 2 : is it impact on isting page performance for $_product->getResource()->getAttribute('custom_attribute_code')?
I have a custom attribute which has 15 text values.
I am using $_product->getResource()->getAttribute($attributecode)->getFrontend()->getValue($_product); . In catalog page I have used ...
- 877
0
votes
2
answers
40
views
What front-end profiler do you use to analyze the performance of the magento 2 site?
What is the best free front-end profiler to analyze site performance magento 2?
- 1
1
vote
1
answer
62
views
Filter by attribute is slow for customer collection using addAttributeToFilter() function
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:
$...
0
votes
0
answers
56
views
Is there a proper way in magento to use stored procedure?
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 ...
0
votes
1
answer
142
views
CPU 100% most of the time - maybe a cron problem?
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 ...
0
votes
1
answer
1k
views
Fastest way to get attribute value of custom product attribute by attribute_code and sku
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 ...
- 33
0
votes
1
answer
73
views
Magento 2: performance issue with Magento\Framework\View\TemplateEngine\Php::render
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 ...
- 877
0
votes
1
answer
23
views
What methods do you use to optimize the work and performance of the backend part (.php)?
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 ...
- 115
0
votes
1
answer
59
views
Database loading Product Collection slow (Minutes)
I've got some third party code here that loads a larger product collection. It takes around 9 minutes to load on decent hardware. We have some 150000 SKU in the database.
Collection:
SQL is:
SELECT ...
0
votes
1
answer
711
views
Magento 2: clear config cache after save config value
Please see this code first
public function setRefreshToken($token, $store = null) {
$scope = 'default';
$scopeId = 0;
if ($store !== null) {
$scope = 'stores';
...
0
votes
0
answers
107
views
Magento 2.4.x website product page GSI score
we are facing a challenge with the Google PSI optimization score for the product page :
Scores on the desktop are above 85.
We have reduced considerable JS payload
Using advanced JS bundle
Most JS is ...
- 1,751
1
vote
3
answers
601
views
Is there a limit for Number of Options for a Dropdown Attribute?
Is there a limit to the Number of Options for a Dropdown Attribute? Let's say I have 10000 different lists of options in an attribute. How that will affect the Magento, website load time, backend data ...
- 109
0
votes
1
answer
162
views
How to increase site performance by CSS and JS blocks from external Extensions
Hi here my site getting E grade rating in GTmetrix because of some CSS and JS files which came with some extensions.
message as Critical am getting:
Resources are blocking the first paint of your page....
- 438
0
votes
1
answer
119
views
Magento2: Slow Catalog Pages Loadtime
I have a website built on the top of magento 2, the problem is when I go to any of the catalog pages, the html takes significant time to load for the first time, as shown in the following screenshot:
...
- 101
0
votes
2
answers
302
views
Slow product save or delete M 2.3.3
I have a webstore with over 400k products that were migrated from m1. Any product that is either saved or deleted takes approximately 25 - 30 seconds per product.
I have done every performance tuning ...
- 5,199
1
vote
2
answers
157
views
Pagespeed performance in Magento 2.3.6
I am trying to improve the performance of magento complying with the requirements of google page speed and I have come across this, I don't know if it is a bug, if I am missing something or what it is ...
0
votes
2
answers
2k
views
How to remove unused js from home page in Magento 2
There are so many js files not used on home page in Magento 2. So, I want to remove it from home page. But, it's not remove still loading on home page.
Non used js example :
jquery/ui-modules/...
- 572
0
votes
2
answers
184
views
Which basic modules do you recommend to disable for performance and other? - Magento2
Which basic modules do you recommend to disable for better performance or other reason?
(I solved a checkout issue after disabling Dotdigitalgroup_Sms module.)
- 1,586
0
votes
1
answer
177
views
Admin Dashboard taking 3 minutes to load after login in Magento 2.3.4
I am noticing very slow initial load of Admin Dashboard (Magento 2.3.4) after the user logs in to admin area. If you refresh the screen after log in, then everything is working normal, also store ...
- 214
0
votes
1
answer
73
views
How to deal with a category which has over 100K products?
Our site (CE version 2.3.4) is extremely slow on the backend and frontend for a particular category which has over 100K items. What is the best way to split this up so that we can see performance ...
- 3
1
vote
0
answers
56
views
Magento 2 Admin Console - Performance Issues
For one of our big projects, our client is using the Magento backend Admin Console for their Project Managers to create orders/customers etc.
Our Customer has time and again reported that the ...
- 11
0
votes
1
answer
489
views
How to preload custom fonts in Magento 2.2
I have a custom font in my theme already added through the "web/css/source/_typography.less".
& when (@media-common = true) {
.lib-font-face(
@family-name: @font-family-name__base,
...
- 101
0
votes
2
answers
566
views
Magento 2.3 suddenly very slow on developer mode
I have been developing on a magento2 docker env (warden) environment for weeks with no problems.
Development mainly on the frontend in developer mode, deactivating only the full_page, block_html and ...
- 187
1
vote
0
answers
204
views
How to load category products in batches? Enable "Allow All Products per Page" without compromising performance
TLTR: How to load category products in batches?
I want to show ALL products for a category and remove the pagination. However, that poses a huge performance concern that I need to address.
Let's ...
- 2,869
2
votes
1
answer
1k
views
Magento 2 high CPU usage after entering production mode
We've been running a Magento 1 site for over 7 years and although cpu usage has been quite high, it's not been a concern as performance seemed fine even, it is a high traffic site after all.
Preparing ...
- 31
0
votes
1
answer
52
views
Caching bundle product pages
our product detail pages (bundle products) load very slowly (10-20 seconds, most of it is scripting time). There is no caching (FPC is enabled) and every time the page is reloaded, the complete ...
- 1
0
votes
1
answer
71
views
Time to first Byte takes over 3 seconds on home page, Fully load time 14s - Magento 2
The site was working fine until recently, the loading speed has dramatically increase, visitor get Internal 500 from time to time. First i thought it was the recent extension I installed, Marisvit ...
- 932
0
votes
1
answer
75
views
Magento extremely slow
My server TTFB wait time is 14 seconds ,
Total loading time is 24.5 seocnds
I have attached my waterfall for GT metrix:
How can I deal with it ??
I am done with following :
I have minified css and JS
...
- 139
2
votes
1
answer
418
views
Magento2 Elastic Search Configuration Issue
I am using following configurations for my magento2 project
Ubuntu 18.04
PHP 7.2
MYSQL 5.7
Elastic Search 7.x
Magento 2.3.5-p1
When i enabled elastic search in magento2 admin panel , the connection ...
- 532
0
votes
0
answers
279
views
Magento2 Category page with color swatches loading too slow
I am using Magento 2.3.5-p1 along with Elastic Load Balancer , My application is hosted in 8GB RAM and 160GB space and MYSQL also hosted on another VM with 8GB ram.
I have 40,000 products which all ...
- 532
0
votes
1
answer
23
views
Magento 1: is there a reason enabled = yes/no and visibility = [1,2,3,4] is not stored in catalog_product_entity
Magento 1: is there a reason status enabled = yes/no and visibility = [1,2,3,4] is not stored in catalog_product_entity
When trying to improve performance one could argue that table ...
- 5,342
1
vote
0
answers
7
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 ...
- 5,342
0
votes
0
answers
96
views
Magento Commerce Cloud 2.3 Maximum Number of Customer Groups?
we are on a Magento Commerce Cloud Pro plan.
For customer pricing in our B2B store, I was wondering if there is any suggestion on how many customer groups I can create without facing issues (...
- 119
1
vote
0
answers
71
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-...
- 89
1
vote
0
answers
308
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,965
1
vote
0
answers
70
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,178
0
votes
1
answer
21
views
Fetch Category Image from collection object without loading category object
I am trying to get the category image from the below code
$collection = $this->_categoryCollectionFactory->create();
$collection->addAttributeToSelect('name','image')
...
- 95
0
votes
1
answer
477
views
How to solve slow performance, slow and long running CRONs in Magento Cloud?
I'm having these two main issues below in my Magento 2.3.2 Enterprise Cloud.
Heavy SQL load and site performance issues.
Long-running and stuck CRON.
How could I solve it?
- 12.4k
1
vote
1
answer
403
views
Why do I need RabbitMQ?
Magento 2 offers easy integration to RabbitMQ, but why and when do I need RabbitMQ installed in my store?
- 12.4k
0
votes
1
answer
551
views
404/410 responses. Either fix the broken links or remove the references to non-existent
following errors are returned when our site is tested on gtmetrix. Could you please share your insights into how to resolve them?
- 660
1
vote
1
answer
664
views
A Magento store runs better in a CPU or Memory optimized server?
I'm preparing my server, I have to choose a performance plan, independent of the hosting provider, which plan makes more sense to a Magento 2 store?
General Purpose
High-performance virtual machines ...
- 12.4k
0
votes
1
answer
111
views
Does enabling category and product flat data will affect performance in Magento 2?
I have huge doubt in flat data feature in Magneto 2.
If I enable product and category flat data in Magento 2.
Will it affect the website performance heavily ?
- 180
2
votes
0
answers
184
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,178
1
vote
0
answers
56
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? ...
- 11