performance - Using $all operator when using Mongodb

Question

I need to design a mongo collection in this structure:

{
   _id: "601af6f8ab9f370c2f7c0c38",
   users: [1111, 2222, 3333],
   chat_id: "chat_1"
},
{
   _id: "601af6f8ab9f370c2f7c0c40",
   users: [1111, 2222],
   chat_id: "chat_2"
},
{
   _id: "601af6f8ab9f370c2f7c0c50",
   users: [2222, 3333],
   chat_id: "chat_3"
},
{
   _id: "601af6f8ab9f370c2f7c0c50",
   users: [2222, 4444],
   chat_id: "chat_4"
}

And i want to perform this query:

db.getCollection('users_collection').find({users: {$all : [2222, 3333]}})

Which will result:

{
   _id: "601af6f8ab9f370c2f7c0c38",
   users: [1111, 2222, 3333],
   chat_id: "chat_1"
},
{
   _id: "601af6f8ab9f370c2f7c0c50",
   users: [2222, 3333],
   chat_id: "chat_3"
}

One of my application assumption is that the users list for each document is small
(most of the lists will be in length 2, and around 10% will be in 3-10 length)
So, the users list can be considered as small sized for all documents.

For the query i have specified above, i need to index users field .

Does anyone had an experience with indexing a list field in mongo and perform
queries with $all operator which supported good execution time on high scale?
(I am estimating around 1B documents in that collection)

Thanks !

question from:https://stackoverflow.com/questions/66060942/using-all-operator-when-using-mongodb

Answer 1

Waitting for answers