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:
Log in to your Magento backend (
http://localhost/packt/admin_packt).Go to Stores | Configuration | Catalog.
Expand the Storefront option and select Yes for both Use Flat Category and Use Flat Catalog Product.
Next, click on Save Config.
After the activation of the flat resource, you will probably get this...
