Enhanced Query Accounts Update Limit?

[sandeepverma3]

Hi Team,

Actually, we have a use case there we have one application and there is no reconciliation process for same, so we have an Analytics report to find the data of user's account who has terminated, and account is also deleted at endpoint. 

So here we are using Enhanced Query to change the account name and appending as "-Deleted on-" and Status as "SUSPENDED FROM IMPORT SERVICE" and in query we are providing all the accounts.

I have one query here while testing we are using 5 to 10 accounts, and it is working but we have 25k accounts in cleanup process. So, I just wanted to know is there any limitation in enhanced query so that we can change our process and can go with in piece of data, or do you have any suggestion on same please let us know.

Thanks

Sandeep Verma

[Raghu]

@sandeepverma3  no limitation it will work, we are using already. check query again

[rushikeshvartak]

There is no limit but 25k is huge hence please go with batch to avoid data issue

[sandeepverma3]

Thank you for reply @Raghu @rushikeshvartak 

[rushikeshvartak]

✅👍Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question.