Who has experience with bulk database in MongoDB, please tell me, how it is designed or not designed (fast or slow counts) to calculate sums, averages, etc., that SQL can be expressed as SELECT SUM(X) FROM T WHERE Y > 10 AND Z < 100
Storage in json/bson kind of hints at the performance of such operations, but the possibility of clustering and storing large amounts of MongoDB is very captivating...
Rodrigo.Raynor answered on October 8th 19 at 02:41
Map/Reduce is one of the main directions of development of MongoDB, the performance of such operations (if done correctly) are much higher than for MySQL. however, it is not one that reason to immediately rush to use it. mongo have really a lot of pitfalls that you never thought in MySQL, such as: aggressive caching of all data-sets a (makes no sense to run mongo from a large dataset, if it turns something else besides Mongo) and global write lock (Mongo in General is designed for quick reading, but the insert in it is hell and horror)
jenifer.Feil16 answered on October 8th 19 at 02:43