I have the requirement to store and retrieve the information that a set of arbitrary sobject records are "dirty" and need to be touch by asynch processes.
I am talking about 10.000 to 100.000 records that I want to mark by calling a method. I also need a method that tells me if a record XYZ is dirty.
Setting an isDirty field on thousands of record would consume multiple Limits, so that's not an option.
I want to persist the information about a set of records that need to be processed later.
Another idea is to store comma-delimited Id list in multiple long text fields, but the only way to search an Id in such fields seems to be Sosl which takes a while to index.
I am out of Ideas?
EDIT: I need a solution which works instantly (synchronous) without any batch. I know that this cannot be done by really modifying all records. That's why I thought about Large Text fields storing Ids and SOSL.