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

Batch insert support for MYSQL worker #305

Open
rasamala83 opened this issue Jan 15, 2023 · 1 comment
Open

Batch insert support for MYSQL worker #305

rasamala83 opened this issue Jan 15, 2023 · 1 comment

Comments

@rasamala83
Copy link
Collaborator

Currently MYSQL worker not supporting batch insert, it is better to enhance functionality to support batch insert to reduce the number of roundtrips while inserting a lot of entries.

@ModEtchFill
Copy link
Collaborator

I think for multiple rows, you can use multiple bind names/positions, e.g.
INSERT INTO tbl_name (a,b,c)
VALUES(1,2,3), (4,5,6), (7,8,9);
https://dev.mysql.com/doc/refman/8.0/en/insert.html

Oracle uses OCIBindArrayOfStruct() [https://github.com/paypal/hera/blob/master/worker/cppworker/worker/OCCChild.cpp#L3588] with the same sql as a single row

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

No branches or pull requests

2 participants