Hi All, I have 3 million records to update the single checkbox in the line level. I’m planning to write map reduce script to process the records but there might be having an issue with the search timeout. Is there any better way to process these large number of records without any issues ?

Be very very careful if you're mass updating updating older transactions. You can end up with payments being unapplied

Thanks @CD for the heads up. Actually, Im updating ISRECOGNIZED flag on the planned revenue sublist of Revenue Plan Record. Since, there are huge number of records Im assuming that there might be having search timeout issue. Is there any alternative way that I can update all these records without any issues in the Map Reduce script?

@Charan 3million lines or records? Just thinking maybe you are bringing back the lines when you don't need to?

@NElliott , Sorry for the confusion. Its 3 million lines.

OK so you may find that can be vastly reduced grouping by transaction and then managing which lines you need to process in your map or reduce stage.

Thanks Nelliott! I have added grouping already. After grouping I'm seeing 3 million results.