Good day, Community, I'm looking for advise on MySQL & MongoDB usage so please let me take your time to describe the situation.
I came to work on e-commerce shop of electrical components with about 10 millions of products. Now all of it stored in awful structure of tables in MySQL. Products stored in 10 small tables, each of them represents individual manufacturer of products and 1 generalized table, where all 10 millions of goods is stored. Those big table serves Sphinx search to implement search on site. All these products being crawled from several APIs and sites on web, so this shop is kind of authorized reseller in our region. The case is that we have to update all products daily and parsing with updating of products takes very long time. I have an idea to start using MongoDB to update and store products and as I think it might take less time than same in MySQL. First question: Am I correct with this statement? Browsing web I've found that some recommend using pymongo, avoiding django rather than mongodb for django. So for your opinion is this statement correct? Also it will be highly highly appreciated if you can share your personal use experience with MongoDB and any information you think be useful. Thank you in advance -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b92afa59-ead1-49e3-b381-1b326ce39fd3%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.