EAV, for those who don’t know, stands for Entity Attribute Value, which a data model used in Magento 2.
Entity: it’s responsible for storing data.
Attribute: It’s a separate property of an entity like name, gender, email address, etc.
Value: It’s basically the value of an entity and attribute.
Together, the EAV structure helps to get flexibility for your data through flexible attributes that are added dynamically.
That being said, let’s look at the main advantage of the EAV model structure.
Advantages of Using EAV Model Structure
- It’s quick to implement.
- It greatly enhances flexibility to store, access, and retrieve data and attributes.
- You can easily add attributes to any entity without having to modify your core database structure.
Based on these advantages, if you’re seriously considering to create and use an EAV module in your Magento 2 project, then you must know that the EAV also has some disadvantages.
Disadvantages of Using EAV Model Structure
- It’s a quite complex structure compared to the flat table structure.
- The EAV flexibility ultimately slows down the SQL Queries’ execution.
So, now that you know all good and bad things about EAV Model Structure, let’s quickly move forward and see how you can create an EAV module by yourself.