Skip to main content
To homepage To homepage

Dear Sir,

  • We connect to our Excel files through a Sharepoint site with some Document Libraries.

    Works fine, but the performance is bad 😑

    -5 minutes wait to Select Tables
    -5 minutes wait to execute Synchronize
    5 minutes wait for execute Full Load

    Is there a way to squeeze some performance out of this ?

    Thanks in advance for looking into this performance issue.

    Regards,

Arthur

 

Hi,

 

what infrastructure are you using and what are the number of files and sizes involved?

Hi Rory,

We are using SharePoint-versie:

SharePoint in Microsoft 365

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 @avanrijn 

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.

 

​@avanrijn can you please try using the TimeXtender Excel Data Source and the latest version of TimeXtender 6814.1?

Hi ​@avanrijn have you had a chance to test with TimeXtender Excel Data Source and the latest TDI version?

Hi 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

 

​@avanrijn thanks for confirming. Have you had a chance to test if adding the drive Id in your setup improves performance?

Reply


Terms and ConditionsCookie settings