Just wondering if anyone had experience of integrating MangoDB and Magento EE 1.14, and use MangoDB to store the product/categoy info? how much is the work to get it work seamlessly? and what's the actual performance improvement with MangoDB replacing the product storage?
Someone posted an article advocating the benefit of using MangoDB for product info, would like to get some insight comments for that:
Here's some reference I found on the web:
That's a great question. MongoDB, being a NoSQL database, allows data to be stored in arrays instead of being normalized as in a relational database like MySQL. This would help in storing the multi-level category structure that Magento maintains.
While Magento maintains different category levels by using a "path" variable, MongoDB would be able to store each product's category structure in a single column (as an array). This would make it easier for analysis.
In terms of performance improvements, this depends on the specific use case MongoDB would be used for. Could you elaborate on the end goal of your analysis?
Akash Agrawal, Analyst - Magento Analytics (http://www.rjmetrics.com)