You need to sign in to do that
Don't have an account?
Help setting an appropriate batch size for a query
I am facing a problem when querying for records where I am not returning all records.
More specificaly, I have a query which is returning approx. 11144 results. I have set the batchSize to 250 and so ultimately only 11000 records are returned. I would assume this is because once 11000 is hit, there is less records left to query than the batchsize. My question is, how do I dynamically set the batchSize to make sure I return all records? I understand i could do this mathematically but was wondering if there was a more straightforward way, or if I am misunderstanding how to use this function.
Thanks
All Answers
Thank's SimonF that was the problem.