Description

Is there a way to optimize the process of downloading a large amount of data so that it does not impact system performance?

Applies to

Query 

Solution

The Data chunk value setting can help performance when you are extracting a large number of records.

By default, for single table queries, Query calculates the optimum chunk value for the run based on query characteristics, such as total field length and number of records to extract. With the data chunk value set, Query fetches only the number of records for each chunk that you can specify. The maximum allowed value for chunk size is 450000 (225000 from 12.0).

Data Chuck v10

Data Chunk v11

A Stop button also appears so that you can stop the extraction if it is running for too long.

Additional information

Data chunk in Studio 11