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

Add DSLContext.bulkStore(UpdatableRecord...) and similar methods #5887

Closed
lukaseder opened this issue Feb 17, 2017 · 1 comment
Closed

Add DSLContext.bulkStore(UpdatableRecord...) and similar methods #5887

lukaseder opened this issue Feb 17, 2017 · 1 comment

Comments

@lukaseder
Copy link
Member

We already have a means of batching several store operations to the server. This is great as it reduces the latencies of server round trips, and in some JDBC drivers, takes advantage of other server side features (such as implicit FORALL in Oracle, if I'm not mistaken).

Another nice API to add would be equivalent bulkXXX(...) methods, that wouldn't use the JDBC batch API, but create a single bulk statement, e.g.

INSERT INTO t (a, b)
VALUES (1, 2), (3, 4), (5, 6), ...

This can be considerably faster in some databases, too. The API would return a Query, which can then still be batched.

@lukaseder
Copy link
Member Author

The INSERT statement itself already offers such functionality.

3.18 Other improvements automation moved this from To do to Done Oct 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
No open projects
Development

No branches or pull requests

1 participant