Book Image

Magento 2 Development Essentials

By : Fernando J Miguel
Book Image

Magento 2 Development Essentials

By: Fernando J Miguel

Overview of this book

Magento is the e-commerce software and platform trusted by the world's leading brands. Used by thousands of merchants for their transactions worth billions, it provides the flexibility to customize the content and functionality of your website. By strengthening your fundamentals in Magento development, you can develop the best solutions and take advantage of the growing market. This fast-paced tutorial will provide you with skills you need to successfully create themes, extensions, and solutions to Magento 2 projects. This book begins by setting up Magento 2 before gradually moving onto setting the basic options of the Sell System. You will take advantage of Search Engine Optimization aspects, create design and customize theme layout, develop new extensions, and adjust the Magento System to achieve great performance. By sequentially working through the steps in each chapter, you will quickly explore all the features of Magento 2 to create a great solution. With ample examples and a practical approach, this book will ensure your success with this astonishing e-commerce management system.
Table of Contents (16 chapters)
Magento 2 Development Essentials
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Indexing and re-indexing data


In the Magento 2.0 life cycle, at a determined point, we will have considerable megabytes of data on the MySQL database, including information regarding products, orders, customers, and payments. To improve its performance, Magento uses indexed tables to provide faster lookups.

However, as your Magento 2.0 e-commerce grows, the indexation feature starts to lose performance too.

In order to correct this issue, you can precompile database relationships using the flat table option in Magento. This technique combines EAV relationships for categories and products in one table to increase the speed of queries. To enable this feature, you can follow these instructions:

  1. Log in to your Magento backend (http://localhost/packt/admin_packt).

  2. Go to Stores | Configuration | Catalog.

  3. Expand the Storefront option and select Yes for both Use Flat Category and Use Flat Catalog Product.

  4. Next, click on Save Config.

  5. After the activation of the flat resource, you will probably get this...