Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Poor performance when updating thousands of data #168

Open
risalfajar opened this issue Oct 9, 2023 · 8 comments
Open

Poor performance when updating thousands of data #168

risalfajar opened this issue Oct 9, 2023 · 8 comments
Labels

Comments

@risalfajar
Copy link

Explain the Problem in Detail

I have thousands of items that I want to update.
Currently, there's only updateDocument() API available, which only updates a single data. Since Apps Script doesn't support parallelization (CMIIW), our only option is to call updateDocument() multiple times synchronously, which is very bad for performance.

Do you have any solution/workaround for this?

Library Version: 33
@abkarino
Copy link

You would need to use a batchWrite operation which would encapsulate up to 500 writes.
However, this feature is not available in this repo yet. There is a Pull Request already open for that.

@MichaelJoo
Copy link

when is the batchWrite function coming along? I am also having the same problem. I need to run hundreds of the app script function...

@abkarino
Copy link

I have no clue.
#144
I was just checking if there has been any updates recently in this repo.

@MichaelJoo
Copy link

@abkarino
Copy link

I already have that feature deployed on my fork, you can use it from there or you can do a new fork and deploy it to your own script.

@risalfajar
Copy link
Author

risalfajar commented Oct 14, 2023

I don't think this library is still maintained, the last release is three years ago.

@grahamearley would you confirm on this?

@MichaelJoo
Copy link

I already have that feature deployed on my fork, you can use it from there or you can do a new fork and deploy it to your own script.

Installed your V4 library and it works like a charm :)

@LaughDonor
Copy link
Collaborator

I don't think this library is still maintained, the last release is three years ago.

@grahamearley would you confirm on this?

I apologize on the lack of maintenance. I have scheduled time to work on this within the coming week to address and catch up to all the issues. I'm aware of @abkarino's changes and should be incorporating them into a release as well. Thanks for your patience! :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants