Dear Sir,
Arthur
Hi,
what infrastructure are you using and what are the number of files and sizes involved?
Hi Rory,
We are using SharePoint-versie:
Formally knows as 'SharePoint Online', is the version of SharePoint that is delivered with Microsoft 365.
TimeXtender version 6766.1
For TimeXtender we are using TimeXtender Data Integration Version 6766.1 (On Premise)
We have 5 document librarys on a Sharepoint Site with a total of 65 Excelsheets.
Regards,
Arthur
Hi,
and what sizes are those Excel files? If you are loading large Excel files, I would not be surprised that it takes time.
Hi Rory,
Loading the data from the excel is not the problem, we can schedule that for in the night.
The performance is bad when we use Select Tables and Synchronize in the ODX interface.
-5 minutes wait to Select Tables
-5 minutes wait to execute Synchronize
Regards,
Arthur
Hi,
yes those seem to have become slower with recent releases. As far as I know the next release should show improvement there. Partially you may be able to speed things up by disabling rowscanning for data types and using .rsd . But then you would have a more manual process.
Hi
This has been an issue with this.
The less specific the location that is being searched the slower it is.
Ideally you point at one drive Id in your setup where the files are located.
If you point at a site or multiple sites it will be very slow at synchronizing.
The amount of files also makes an impact, but not as much as this.
The TimeXtender Excel data source can connect to Sharepoint as well.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
