I really don't understand how to improve the performance of my query using index. db.Vendite.aggregate([{$group: { _id: { anno: "$anno", mese: "$mese", cod_age: "$cod_age", cod_int: "$cod_int", cod_cli: "$cod_cli", cod_linea_comm: "$cod_linea_comm", cod_sett_comm: "$cod_sett_comm", _art: "$cod_art"}, vendite_quantita: { $sum: { $add: […
I need to insert a 181 KB json file into a mongo collection, the restriction is that it needs to be done using mongosh. json_file_path=/some/path/file.json json_file_string=$(cat $json_file_path) /mongo/path/monhosh $databaseName --tlsCertificateKeyFile someAuthDetails --tlsCAFile someMoreAuthDetails --quiet --eval "db.test_collection.insertOne(${json_file_string})" this seems to be…
The following command executed with legacy mongo shell: mongo --quiet << EOF show dbs EOF provides this output admin 0.000GB config 0.000GB local 0.000GB However, the same command with new shell (mongosh) $ mongosh --quiet << EOF show dbs EOF…
I am trying to retrieve some documents from a MongoDB collection (called expenses). Here you are the entire database, obtained using db.expenses.find(): [ { _id: ObjectId("65708c6237b62067296a398f"), date: '2013-10-21T13:28:06.419z', description: 'playstation', category: 'miscellaneous', cost: 499, users: [ { username: 'Giacomo', amount:…