Questions tagged [optimization]
The optimization tag has no usage guidance.
161
questions
0
votes
2answers
40 views
how to optimize queries in magento 1.9 with lots of attributes (over 500)
I have a website running Magento 1.9 which is flooding mysql with slow queries like this
SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `...
0
votes
0answers
14 views
Magento database optimization slow query
my website was getting internal 500 error intermediately, my hosting provider(siteground) told me that the magento database was running slow queries ( 80 in the past 24 hours), which cause spikes on ...
0
votes
0answers
13 views
Sever Suggestion Setup
Hello where trying to build magento 2 website from shopify 10k sku
It is better to use a dedicated server with Intel Xeon E5-1650V3 64GB ram with 512 SSD Drive(Datacenter)
Or Use Cloud Hosting with a ...
0
votes
0answers
127 views
Magento 2: Remove unused JS from home page
There are several unused JS files which we do not use on the homepage. JS files are:
jquery/ui-modules/datepicker.js
jquery/ui-modules/timepicker.js
moment.js
jquery/ui-modules/sortable.js
jquery/...
0
votes
0answers
20 views
Magento store optimization Suggestions?
I want suggestions regarding Magento store optimization :
Are these two Extensions Useful which one between these two should be preferred to buy??
https://mirasvit.com/magento-2-extensions/full-page-...
0
votes
1answer
18 views
Magento Command for bulk Optimizing existing Product images
How to optimize existing Product images via commandline, similar to resize command.
php bin/magento catalog:images:resize
https://docs.magento.com/user-guide/catalog/product-image-resizing.html
This ...
0
votes
2answers
22 views
Everything in one module or split up in multiple?
Module
We're creating a webshop and are mostly creating every file we need in app/code/vendor/module right now. This means we have lots of different features like widgets and logic for multiple ...
0
votes
1answer
34 views
How to optimize images in magento2
My site speed is very slow. Can anyone please let me know how can I optimize all the images? So, my site loading can be faster.
3
votes
0answers
47 views
Defer merged css in Magento 2
I need to Defer merged css using JavaScript. Is there any possibilities to defer merged css. Example code i want to do.
<noscript id="deferred-styles">
<link rel="...
0
votes
0answers
15 views
Optimize grid collection for huge data set Magento 2
I am working on creating an admin grid for sales_order_item table. There are probably a hundred million rows in the database and when I use the collection to filter and load data into the grid, it ...
0
votes
0answers
24 views
Product page taking a lot of time to move automatically to next page
We are using template monster Theme Magitique
Link: https://www.templatemonster.com/magetique.html
We are using varnish cache as well
The product page loading time took 14 seconds in loading but ...
0
votes
1answer
51 views
WebP Images Google Safari Image Optimization
WebP Images Google Safari Image Optimization
We are using Amasty Google Page Speed Optmization Extension for Magento 2 which has Image Optimization options - There are options to covert images to webp ...
0
votes
1answer
109 views
Ram memory issue on Magento 2.3.4 website
I have a Magento 2.3.4 website on my server in Production mode.
When I check memory usage with "top" command, I got a very high memory usage like this:
There are so many php-fpm processes
...
0
votes
0answers
7 views
Filter orders that have null value in sku in its order items Magento 1
So far i have tried this
<?php
define('MAGENTO', realpath(dirname(__FILE__) . "/.."));
require_once MAGENTO . '/app/Mage.php';
umask(0);
Mage::init();
Mage::app()->addEventArea('global'...
1
vote
1answer
12 views
Code optimization, adaptation to a large number of conditions
I need to make a condition, if the server code has a certain value, then it will set the appropriate currency.
I did this via an if else condition. But if there are many 5+ conditions, it will look ...
0
votes
2answers
523 views
Magento 2 Varnish issue with images
Last days was trying to investigate why my magento 2.3.5p1 instance needed for uncached pages about 10-11 secs to load, measured with timer. I identified that the issues was Porto's template mega menu ...
0
votes
1answer
33 views
How to reduce a large Magento 2 installation?
I'm using Magento 2.4 and my installation is using 200GB, I'd like to reduce it.
I want to remove old logs, backups, caches, duplicated images and etc.
How could I optimize it?
1
vote
1answer
56 views
Magento 2 Store Optimization?
I want to optimize magneto store.
Magento store is deployed on Aws. I have not installed SSL certificate yet because It is still in development phase so I have not mapped it with domain name it is an ...
0
votes
1answer
31 views
Magento store optimization?
I am facing problem the total number of request send to server is 223 which is huge and due to which loading time is 13 seconds
How can I reduce number of elements
I have merged and minify JS and css
0
votes
1answer
339 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?
0
votes
1answer
61 views
How to optimize my indexes cron execution?
I'm checking how to optimize my cron execution in the reindex action, and I saw the option to run the index job in a separated process.
How does it work? can it be helpful to optimize the execution?
0
votes
1answer
38 views
Magento 2 How load product by sku and boot the system minimally?
Me need minimal load system that get ONLY: Product Name, Product Type, Product Url, Thumbnail Url, Price, Sub products for Configurable.
Preferably use catalog_product_flat_ table (i think it's good ...
0
votes
5answers
506 views
Magento 2.2.2 site loading speed is very slow
I am using Magento 2.2.2 EE nginx + varnish + cdn still site is loading very slow for the very first time when I flush the cache from terminal using command 'php bin/magento cache:flush' or from ...
1
vote
1answer
128 views
Magento 2 Js optimization
I use bundle js in magento2 now when i run command the error is comming
Error: ENOENT: no such file or directory, open
'E:/projecct/tts-core-au-deveopment/pub/static/frontend/Sm/custom/en_AU/...
0
votes
0answers
49 views
How can I add critical JS on Magento 2.3.3?
Magento 2.3.3 has "Move JS code to the bottom of the page" function which moves all JS code to bottom of the page.
I need some JS code(Seal Verification Code which showing verification icon) not ...
0
votes
1answer
34 views
Developer mode enable js merging
I searched for an answer, but I didn't find one.
I like to enable js merging and compressing in Magento 2 developer mode.
Is this possible?
I enabled them in admin, but the merging is not working
0
votes
0answers
39 views
How to speed up the magento 2.2.5 website in production mode
How to speed up the Magento 2.2.5 website in production mode
I have tried all default options but still its very slow
website url : [https://www.thedottedi.in/]
please help me out on this
Thanks ...
0
votes
0answers
30 views
How CSS loads partially or not at all in Magento 1?
I have an extremely weird problem that I face for the first time.
From time to time (it's really absolutely random), the CSS of a Magento 1.9.3.10 store is not fully loaded. It can happen on a ...
1
vote
0answers
71 views
How to fix a long Time to Interactive in google pagespeed : Magento 2
Can anyone help me to fix
" Time to Interactive "
In magento 2?
I really hope anyone can help me or tell me how to fix it
Bad score on google pagespeed - 38 sec
0
votes
0answers
25 views
Magento 1.9 Localhost first request Wait Time very high
I know there had been many queries regarding the topic and I went through almost all of it.
The point where my query is slightly different from the rest is that my magento website runs pretty well in ...
4
votes
2answers
2k views
How to enable CSS Critical Path in Magento 2
How to enable CSS Critical Path in Magento 2.3.0
Reff: https://devdocs.magento.com/guides/v2.3/frontend-dev-guide/css-topics/css-critical-path.html
When I try to enable, I'm getting the below error.
...
1
vote
1answer
55 views
get customer who have not placed order from last 3 months but in optimized way
I need to optimized my answer.
$start=2019-05-18 00:00:01;
$end=2019-05-18 23:59:59;
$customerArr=array();
$customers = Mage::getModel('customer/customer')->getCollection()
->...
0
votes
1answer
39 views
Magento 2 optimization - loading time is high
High configuration server with Redis configuration.
Gtmatrix - https://gtmetrix.com/reports/mastersdirect.masters-sp.com/UQcit4p9
Waiting time is 2.68 s.
Created a normal controller and exit in the ...
0
votes
0answers
31 views
how to optimize storage problem in magento 2
magento ver 2.2.6
i have 2,000 products but
storage 16GB (pub/media folder 14GB)
how i can optimize this storage problem..
0
votes
1answer
94 views
Recommendation for Free Lazy Loading Extensions Magento 2
I'm looking for a recommendation for free lazy loading extension that is likely works for Magento 2.2.9 with infortis ultimo theme.
here are some list i found:
-welt MAGENTO 2 LAZY LOAD PRODUCTS ...
0
votes
1answer
42 views
Consistent URL issue on magento1.9 site optimization
Getting issue in Website Optimization:
Serve resources from a consistent URL All url are of small image of different products on the same page.
https://www.text-machines.com/media/catalog/product/...
4
votes
3answers
318 views
Magento 2: I am not aware about Magento optimization. Can you please share the steps for this?
I am not aware about Magento optimization. Can you please share the steps for this? How to compete with this?
Thanks
1
vote
1answer
33 views
Optimising the Magento 2 backend
In general, the loading times of pages in the backend are around 2 seconds. Can't really argue with that. However, I have noticed that Grid Pages (such as the Order and Products) require additional ...
0
votes
2answers
127 views
Improving Performance
We run a Magento 1.9 online store. It contains 110,000 products. We are running into issue around long page load times for category pages and product pages.
Dedicated WebApp server specs:
- Apache 2....
2
votes
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 ...
0
votes
1answer
30 views
Admin Menu doesn't slide out and configuration menue doesn't open. Also buttons not working
Preconditions (*)
Magento 2.3.1
Ubuntu 18.04.2 LTS
PHP 7.2.17
Working in dev environment and and enabled few optimization parameters which made admin panel inaccessible and buttons were don't appear ...
1
vote
3answers
2k views
Magento 2: Ram memory issue
I have Magento2 website on production mode. And i have 8gb ubuntu 16.04 server. But i have checked ram memory uses 99% so my website is working slow.
Please any one tell me why used my memory 99%?
...
1
vote
2answers
306 views
Merge JS/CSS files
I'm trying to compress the code files on my magento 2 store. And so we wanted to use the Merge JS/CSS files in the magento 2 admin.
We are not programmers, and we would like to not have to contact ...
0
votes
7answers
3k views
Magento 2 increase site speed
Magento 2 website speed very slow as per https://developers.google.com/speed/pagespeed/insights/
Result of site:-
Reduce server response times (TTFB) - 1.68 s
JavaScript execution time - 2.9 s
...
2
votes
1answer
96 views
magento 2 remove root lib/web/ js files from home page
Magento 2 sends around 300 request on home page so speed is very slow.
Also, bundling create very large file so its taken time to load resources.
I want to remove js from root lib/web from home page.
...
0
votes
1answer
604 views
Magento 2 Optimization Eliminate render-blocking resources on a Merged css and js files
I am optimizing the Magento 2.2.6 Website.In Google Page Speed test suggestion Eliminate render-blocking resources.
There are following files
/pub/static/version1555309524/_cache/merged/...
1
vote
0answers
101 views
Magento 2 Issue with JavaScript and CSS Merge
I have checked my site for speed and it was requesting 258 requests.
I have merged all JavaScript and CSS files and again tested it but still 251 requests are there.
While in view page source I can'...
0
votes
2answers
238 views
How to optimize the images of a magento 2 site?
There is a site which have a lot of images of high quality because of which the load time of site is quite high. It is impossible to optimize images one by one as we have many images. So could anyone ...
0
votes
1answer
61 views
Minify CSS Magento 2
It possibile to fix this issue?
Where is the file that i can minify?
How can i find it?
Thanks :)
Magento 2.2.2 CE
0
votes
0answers
44 views
Magento 2 Optimization [duplicate]
I'm trying to optimize my website.
On Gtmetrix it is giving me this "warning"
How can I fix this issue "Use cookie-free domains"?
