Sir, thank you for sharing this tutorial video. I need to ask one question -- There is one use case as how to modify index because migrating all data impacts performance. Please suggest some solutions.
Thanks for your comment. I don't think I understood your question but let me try. You indexes are dynamic, every time you insert a new data, your index is modified to accommodate the fast search. Hope it helps Thank 🙏
Amazing, Sir I have a question which is confusing me a lot. I hope you'll fix it for sure... I have a collection with 30M documents. each document contains 4 keys and 4 values like (Bill_id, Amount, City, Tel). How should I create indexes ? Should I use 4(square) indexes? like 36 indexes ?
Great video! Using mongoimport we have a param specifying the numinsertionworker for parallel insertion do we have a similar param in pymongo, if not do you suggest any ways that we could achieve parallel insertion using python?
hi, i have a question how can i used both direction sorting in compound index for example : i have compound index "active_1_name_1__id_1", name is used for sorting , i want to used name for ascending sorting as well as descending sorting
Most of the time 'FETCH' step execution time will be ~0. Shouldn't we look at Actual query execution time to see performance benefit after applying the indexes ?
Thanks for your comment MongoDB doesn’t know if the document at the 10th place is the only document matching the criteria.. so it needs to search Hope it clarifies your question Thanks again 🙏