hi,
i have a collection with 207M records, i was using a framework which was saving relationship fields as string , now new version is saving it as ObjectId, now the issue for me is how do i approach to implement this , i can update records in batch like 50k in one go with mongoose, loop ?
what other options do i have ? kindly share your experience or any suggestion on this,
RAM and CPU is not an issue as i have 2xRAM available in comparison to my whole dataset + index , i have 12 Core CPU dedicated server.