Questions tagged [optimization]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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"?