Is there a way to optimize the process of downloading a large amount of data so that it does not impact system performance?
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.