[ad_1]
I have 10 billion documents like this:
{ “_id” : “ba93cede1186ad0681ef3bc751ad8629_8bb8d1696e299db0b8d7f2327c48c39f”, “aId” : “195d15b417b54b5fb01100c80c043921”, “bId” : “ba93cede1186ad0681ef3bc751ad8629”, “pId” : “8bb8d1696e299db0b8d7f2327c48c39f”, “type” : “friends”, “describe” : “some words...”, “createdDate” : ISODate(“2022-06-04T08:42:55.383Z”), “modifiedDate” : ISODate(“2022-06-04T08:42:55.383Z”) }
1、I need to create index on fields (aId,bId,pId,type,createdDate)
2、querying by indexs (such as:aId+bId+createdDate) needs to return in 1~2 seconds
Can mongodb handle this?
How many machines do i need?(16 core Cpu,128g Memory,2T HDD)
[ad_2]