There are dozens of ways how we can get in touch ,whether it is phone, email, any of existing messengers, casual meeting or conference. No matter how it happened, but as a result we are getting the general description of your idea. After that we have to appoint our next meeting (and means of communication) for further discussion of the project. It would be very helpful to prepare the following materials on your part:
If your store has several thousands SKU’s, you should pay attention to this aspect. Flat Catalog can really improve the performance of your online store.
The flexible EAV (Entity Attribute Value) gives Magento users the ability to customize product attribute, but it affects performance in a bad way, because object attributes are stored in multiple tables instead of one very large table. The fact that attributes are stored in multiple tables, SQL queries get complex and long. Each flat catalog feature creates new tables and each row contains all data.
The Flat Catalog can help to reduce the number and complexity of catalog queries and improve the response time.
How can you enable it in Magento 2.0?
Navigate to Stores => Configuration => (Catalog) => Catalog.
Then select “Yes” in “Use Flat Catalog” to enable Flat Catalog Category.
And “Yes” in “Use Flat Catalog Product” to enable Flat Catalog Product.
When complete, press “Save Config” button.