Changing the Batch Size in Queries

By default, the number of rows returned in the query result object (batch size) returned in a query() or queryMore() call is set to 500. WSC clients can set the batch size by callingsetQueryOptions() on the connection object. C# client applications can change this setting by specifying the batch size in the call QueryOptions portion of the SOAP header before invoking the query() call. The maximum batch size is 2,000 records. However this setting is only a suggestion. There is no guarantee that the requested batch size will be the actual batch size. This is done to maximize performance.

Note

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.

The following sample Java (WSC) code demonstrates setting the batch size to two hundred and fifty (250) records.

public void queryOptionsSample() {
  connection.setQueryOptions(250);
}

The following sample C# (.NET) code demonstrates setting the batch size to two hundred and fifty (250) records.

private void queryOptionsSample() 
{
    binding.QueryOptionsValue = new QueryOptions();

    binding.QueryOptionsValue.batchSize = 250;
    binding.QueryOptionsValue.batchSizeSpecified = true;
}