When I go through the Salesforce developer interview questions, I have got this one:
What’s the maximum batch size in a single trigger execution?
Well, I don't know the answer of this one. And I don't even know what is batch size. So I googled about it. And see the following document: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_changing_batch_size.htm
In it:
You can change the batch size (the number of rows that are returned in the query result object) that’s returned in a query() or queryMore() call from the default 500 rows.
The maximum batch size is 2,000 records
The batch size will be no more than 200 if the SOQL statement selects two or more custom fields of type long text. This is to prevent large SOAP messages from being returned.
So according to this document, it seems to me the default number of rows returned in a SOQL call is 500 and the maximum we can set is 2000. However, I do remember I have queried more than that number before (maybe I remembered wrong?)
Is that limit still there? And is it only for triggers or for everything?