Neoshop is a Premium Responsive and Retina Ready Magento theme with an advanced admin module. It’s extremely customizable, easy to use and fully responsive. Suitable for every type of store, Neoshop comes with lots of awesome features like one page checkout, ajax price slider and ajax cart, revolution slider,google rich snippets, new products slider, bestseller products vertical scroller, onsale products slider and many other features that will help you improve your sales. All these amazing features are blended together in Neoshop – your powerful, stylish and attractive responsive Magento Theme.We are sure that it will satisfy all your needs!
Difference between EAV and Flat Catalog
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
EAV database model is used by Magento for easy upgrade and development as this model gives more flexibility to play with data and attributes.
When flat catalog is enabled in Magento then all the above product attributes (id, name, price) are kept in one table named like catalog_product_flat. Then Magento fetches product data from the flat table rather than joining all the other smaller tables.