Skip to content
This repository has been archived by the owner on Feb 25, 2022. It is now read-only.

fetching data from sharepoint is very slow #135

Open
tripodsan opened this issue Jul 20, 2020 · 3 comments
Open

fetching data from sharepoint is very slow #135

tripodsan opened this issue Jul 20, 2020 · 3 comments
Labels
bug Something isn't working

Comments

@tripodsan
Copy link
Contributor

Description
the requests to fetch the query index from sharepoint are very slow:

image

It takes about 4-5 seconds for each request:

  • getting the worksheets
  • checking for tables
  • returning the used range
@tripodsan tripodsan added the bug Something isn't working label Jul 20, 2020
@tripodsan
Copy link
Contributor Author

tripodsan commented Jul 20, 2020

another test, where it's a bit faster (1.5-3 seconds):

image

@tripodsan
Copy link
Contributor Author

another one where it takes 2-3 seconds:

image

@tripodsan
Copy link
Contributor Author

when supporting #118 it could be reduced it to 1 request, getting the used-range directly, since the table and sheet names are known before.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant