Skip to main content
Solved

Microsoft Excel Online


avanrijn
Contributor
Forum|alt.badge.img+2

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

 

Best answer by Thomas Lind

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.

 

View original
Did this topic help you find an answer to your question?

10 replies

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 651 replies
  • November 12, 2024

Hi,

 

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


avanrijn
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • 36 replies
  • November 12, 2024

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


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 651 replies
  • November 12, 2024

Hi,

 

and what sizes are those Excel files? If you are loading large Excel files, I would not be surprised that it takes time.


avanrijn
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • 36 replies
  • November 12, 2024

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


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • 651 replies
  • November 12, 2024

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.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1017 replies
  • Answer
  • November 12, 2024

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.

 


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


avanrijn
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • 36 replies
  • November 21, 2024

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

 


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings