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.

Sign up for GitHub

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

Jump to bottom

[Feat] Investigate if possible to add support for mutations. #720

Open
vi3k6i5 opened this issue Oct 11, 2021 · 0 comments
Open

[Feat] Investigate if possible to add support for mutations. #720

vi3k6i5 opened this issue Oct 11, 2021 · 0 comments
Assignees
@vi3k6i5
Labels
api: spanner Issues related to the googleapis/python-spanner-django API. priority: p3 Desirable enhancement or fix. May not be included in next release. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.

Comments

@vi3k6i5
Copy link
Contributor

vi3k6i5 commented Oct 11, 2021

Spanner has support for mutations, investigate if it's possible to use that instead of batch inserts.

https://cloud.google.com/spanner/docs/modify-mutation-api

Mutations are much faster than batch inserts as shown in benchmarking results.

Benchmarking performance:
Action | django | python-spanner
insert_many_rows_with_mutations | 0.723594 | 0.019262
@vi3k6i5 vi3k6i5 added type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design. priority: p3 Desirable enhancement or fix. May not be included in next release. labels Oct 11, 2021
@vi3k6i5 vi3k6i5 self-assigned this Oct 11, 2021
@product-auto-label product-auto-label bot added the api: spanner Issues related to the googleapis/python-spanner-django API. label Oct 11, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@vi3k6i5 vi3k6i5

Labels
api: spanner Issues related to the googleapis/python-spanner-django API. priority: p3 Desirable enhancement or fix. May not be included in next release. type: feature request ‘Nice-to-have’ improvement, new feature or different behavior or design.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@vi3k6i5