How to update all Records in a database without Query All

awkcowell

I have a large database(1.5 Million Records), and am wanting to go through and update a field for each of them. What would be the best way to do this given that Query All seems to be returning a memory issue. Thanks for any help!

Edit: At the moment my plan is to update them in chunks, just curious if there is a better way?

Michael Udinski

Hi @awkcowell, you will want to use the stream return type on your query all records and perform this through a background task due to the size of your database.

awkcowell