Hi,
I'm looking for some information to try and speed up the execution of the queries. To run 3 queries in a single workbook, it is taking the plug-in a minimum of 10 min to execute. I've tried on multiple machines and some take longer than that. Is there anything that can be done to increase performance?
The queries were built myself, all machines are running the latest compatible version, Windows 7 Enterprise, and Office 365 Pro Plus.
Thanks,
Dolores
Refresh Delayed Execution
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Refresh Delayed Execution
We have greatly improved the speed of data import. If your query selects a lot of data, then these changes should help you. But if you select not so many records from a slow data source (for example, Magento) these changes won't help.
We are planing to release a next public build of Excel Add-ins in the nearest future. We will post here when the corresponding build of Excel Add-ins is available for download.
We are planing to release a next public build of Excel Add-ins in the nearest future. We will post here when the corresponding build of Excel Add-ins is available for download.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Refresh Delayed Execution
New build of Devart Excel Add-ins 1.6.623 is available for download now!
It can be downloaded from http://www.devart.com/excel-addins/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=35958
It can be downloaded from http://www.devart.com/excel-addins/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=35958