Magento uses the EAV database structure for storing the Products and Categories. Magento is extremely flexible because of the EAV database structure. To know more about the EAV database structure see my post on EAV database structure in Magento.
But EAV database model is not much faster in terms of the performance. This is because we need perform query on three tables to get single data. This is the main drawback of the EAV database model.
But don’t worry at all, because magento has provided the option to use the EAV database structure or not. Yes, you have read correctly. We can enable the flat database model in model and can store the products and categories in traditional way which is called Flat Database Structure.
After updating to Flat category and products you need to Re-index the data from the Magento Index Management.
Note: It is recommended to use the magento Flat Database for Products and Categories if you are facing performance related issues with magento.
Avinash Zala is leading various projects which deals with the various technology involved with the web. A combination of perfect technical and management skills. Avinash would like to chat with you and convert your imagination into the working system. You can get in touch with him on Facebook and Twitter.
View all posts by: Avinash