I have a large collection catalog, with a count of 200 million rows.
I want to schedule and replicate into a new collection catalog_filter_replicated with a filter like clientId:“123”.
Every time when schedule script executes, new rows should be inserted and the old one should update the target one.
The performance factor is important here. Please suggest the best way to replicate (insert / update) a large collection into a new one with Filters.