Excel Add-ins. Slow Data Extraction (Database Providers)
Navigation: Supported Data Sources → Supported databases:
Data loading into Excel may work noticeably slower compared to executing the same query in other tools.
Performance can be improved by adjusting the Buffer size parameter.
Path: Devart → Option → Import → Data → General
Set the value to several thousand or tens of thousands. The optimal buffer size depends on the row size and may differ for various tables, so it is recommended to experiment to determine the best value.
Changing this parameter increases the speed of reading and updating data. However, note that the progress indicator will refresh less frequently as the buffer fills, which may give the impression that the process has stopped. In fact, the operation continues during these periods.