We have an integration for data synchronization between Salesforce and our system.
But meanwhile, we run into a performance problem because we are querying a lot of "old" campaigns with uninteresting data.
The data of interest are custom objects (only modified or new), these custom objects are in a many to one relationship to the standard campaign object.
My idea would be to mark the campaign as "uninteresting" with the help of a custom field.
If all the custom objects for a campaign haven't been modified since a certain amount of time or no new custom objects were added to that campaign, mark the campaign as "uninteresting.
What would be the best way to achieve this? Some sort of timer job?
I guess there are different approaches to achieve our goal every idea is highly appreciated.
Thanks in advance.