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.
Related Articles
Excel Add-ins. Slow Data Extraction (Cloud Providers)
This article is for Excel Add-ins (Clouds). Navigation: Supported Data Sources → Supported cloud applications: When working with Excel Add-ins connected to cloud sources such as Salesforce or QuickBooks, data loading may be noticeably slower than ...Loading Data from Excel
This article is for Excel Add-ins. Excel Add-ins can be used to work with external data sources and update data directly in Excel. A common question is whether it is possible to load arbitrary data from an Excel worksheet into a connected database or ...Excel Automation
This article is for Excel Add-ins. The scenario involves building an automation system based on Devart Excel Add-ins, with data transfer between different sources, synchronization, and automatic data updates. Solution Devart Excel Add-ins are ...What is the difference between Standalone applications and Add-Ins?
dbForge offers a suite of powerful MiniTools designed to streamline database development and administration. These tools come in two primary forms: standalone applications and add-ins, each catering to distinct user needs and workflows. 1. dbForge ...Devart tab disappears in Microsoft Excel
Microsoft Excel may disable Add-ins automatically if errors occur or if they take too long to finish their operations. However, you can re-enable the Add-ins without needing to restart your operating system. For this, follow the steps below: Open ...