MongoDB Compound Index and Indexing

[@Pixelflames1]

I'm so exited but i still have no idea how to implement it in my code or on my mongodb server through the terminal

[@lalitbelwal7231]

is there any video on composite indexing in case size is exceeding

[@Cognitive-Programmer]

No not yet on my channel..but I intend to talk more on topic of index in upcoming videos.. sorry about that 👍

[@lalitbelwal7231]

@@Cognitive-Programmer no problem I will be happy to see that in future as I am stuck already in that soup.

[@msbasera]

Great Explaination Sir ❤️

[@Cognitive-Programmer]

Thank you so much for your comment 🙏

[@IdanBernard]

Great video, thank you so much!

[@Cognitive-Programmer]

Thanks a lot for your comment 🙏

[@reyanshspeak2847]

How to specify two custom indexes on two different fields in the compound autocompleted query?

[@MahenderPratapSingh-c6f]

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

[@koushikdugk007]

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?

[@shreyashachoudhary480]

Loved it

[@Cognitive-Programmer]

Thank you 🙏

[@thirumurugand9287]

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 ?

[@Cognitive-Programmer]

Hi
Thanks for your comment
Yes, to properly evaluate the performance, it needs to be checked with large dataset

[@prasadshivan79]

Hello Sir, Is it possible to get indexStats using pymongo?

[@lalitbelwal7231]

easy explaination

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@komalsingla6032]

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.

[@Cognitive-Programmer]

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 🙏

[@Vijay-Yarramsetty]

audio quality is good in this video

[@Cognitive-Programmer]

Thank you 🙏

[@funnyclipz520]

awesome explanation... can you share the mongodump in the description?

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@arbazahmed7748]

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 ?

[@fanzhang8823]

Just put keys and sorted field(s) into compound index, put exact march field(s) at first, then sorted filed(s) and ranch match field(s) into the index

[@Pray4Tony]

Thank you

[@Cognitive-Programmer]

Thanks 🙏

[@nizarbouali5837]

Thanks !!

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@sujith5441]

Compound Index size seems very large

[@monireol]

Thanks a lot

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@iampiyush100]

Supposed if our document on 10th place they why mongodb search 10000 documents?

[@Cognitive-Programmer]

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 🙏

[@monireol]

Limit is 64

[@Cognitive-Programmer]

Thanks for your comment 🙏