+2Dear Sir,
Arthur
Best answer by Thomas Lind
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.
+7Hi,
what infrastructure are you using and what are the number of files and sizes involved?
+2Hi 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
+7Hi,
and what sizes are those Excel files? If you are loading large Excel files, I would not be surprised that it takes time.
+2Hi 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
+7Hi,
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.
+5Hi
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.
+5
+5Hi
+2Hi Christian,
No I haven’t.
We plan to go live with TX version 6766.1.
Your suggestion is not on the table right now.
We will upgrade to the latest and the greatest version of TimeXtender somewhere next year.
Regards,
Arthur
+5
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
