hey
My question is about a query with many or conditions.
I want to get all accounts where (id = id1 and date > date1) or (id = id2 and date > date2) or (id = id3 and date > date3) etc (can be up to a 1000, maybe more)
I have compound index of id and than date
will that query work well, performance wise? Is there a better way to do it?
Im new to mongo and will be happy for any suggestions
Thank you!