Change 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 calling setQueryOptions() 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.

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

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

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

1private void queryOptionsSample() 
2{
3    binding.QueryOptionsValue = new QueryOptions();
4
5    binding.QueryOptionsValue.batchSize = 250;
6    binding.QueryOptionsValue.batchSizeSpecified = true;
7}