December 2021

Optimising Magento 2 in easy steps

Some (fairly) simple step-by-step instructions to ensure your Magento Belfast 2 store is running the best it can.

While most of these options should only require access to Admin panel, most are dependent on your web server running specific software to allow them to work. Check with your hosting provider that Elasticsearch and Varnish are enabled and running.

Clear Database Logs

The first step to keeping a Magento install lean and fast is to remove or clear down the sometimes excessive log tables that accumulate in Magento. This can be completed through the Magento Admin Panel and doesn't require technical knowledge.

You can use a value of "1", this will keep messages in the logs for a maximum of one minute before they are cleared out. Be careful not to change this value to "0" This will stop the logs being cleared completely, not reduce them.

Enable Elasticsearch

Elasticsearch is a powerful and highly scalable distributed search engine that is used by high-volume sites such as eBay, Wikipedia and GitHub. The implementation of Elasticsearch includes both search suggestions and recommendations.

For this to work you will need to have your web server pre-configured with Elasticsearch

Flat Catalogue Tables

Magento includes the option to generate "flat" product and category tables. What this does is create additional tables for the products and categories which don't use the standard Entity-Attribute-Value (EAV) set-up. EAV is great for making a scalable applicaton, but it can be cumbersome process when loading lots of values.

Flat tables help by creating dynamic tables that are indexed to include just the attribute-values needed and reducing the number of SQL queries. The bigger the Magento website the bigger the impact using Flat tables will have.

You will be prompted to update your store's Cache. Follow the instructions.

Varnish Caching

Varnish is a caching tool that works as an additional layer between the web server and the user. Adobe recommend using Varnish with your Magento install.

For this to work you will need to have your web server pre-configured with Varnish


My Magento Expertise

If you are planning a new e‑commerce store, considering a platform upgrade or looking for ongoing Magento support, I can provide the expertise you need. Based in Northern Ireland and working with clients locally and internationally, I deliver solutions that help businesses grow.

Contact me to discuss your Magento project

More Magento posts

Magento database structure

The database structure of Magento is designed to store and manage various aspects of an e-commerce website, including products, orders, customers, and more. Understanding the Magento database structure is crucial…

Continue reading

Accessibility in ecommerce websites

In the digital age, where online shopping has become an integral part of our lives, ecommerce websites hold the key to business success. Amidst the rush to create visually appealing…

Continue reading

Using Magento to get small businesses online

For small businesses aiming to establish a formidable online presence and drive sales, Magento emerges as a powerful e-commerce platform offering a suite of features tailored to their needs. Scalability…

Continue reading

How can I speed-up my Magento website?

Speed optimisation is crucial for a Magento website as it directly impacts user experience, conversions, and search engine rankings. You should prepare your server so it is set-up to use…

Continue reading