Wednesday 4 June 2014

Why Magento use EAV database model ?


In EAV database model, data are stored in different smaller tables rather than storing in a single table.
Product name is stored in catalog_product_entity_varchar table,
product id is stored in catalog_product_entity_int table,
product price is stored in catalog_product_entity_decimal table
Magento Use EAV database model for easy upgrade and development as this model gives more flexibility to play with data and attributes.

reference: http://jaseir.com/magento/why-magento-use-eav-database-model/

No comments:

Post a Comment