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 updates for SQL statements #94

Closed
flyway opened this issue Jun 25, 2013 · 3 comments
Closed

Batch updates for SQL statements #94

flyway opened this issue Jun 25, 2013 · 3 comments

Comments

@flyway
Copy link
Collaborator

@flyway flyway commented Jun 25, 2013

Original author: kaczanow...@gmail.com (June 06, 2012 07:34:06)

As discussed on http://stackoverflow.com/questions/10899727/executing-more-than-one-statement-at-once it would be nice to have an option of "batch updates".

In short, current implementation sends statements to DB one by one which results in very slow updates (in case of large files and net lag).

Some DB vendors (e.g. PostgreSQL) support such thing natively.

Original issue: http://code.google.com/p/flyway/issues/detail?id=274

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Oct 16, 2014

Not so trivial, due to a number of databases rejecting SELECT statements as part of batches.

This also does not provide clear performance advantages for every data. Will have to be enabled selectively.

Loading

@axelfontaine axelfontaine added this to the Flyway 3.2 milestone Oct 16, 2014
@axelfontaine axelfontaine removed this from the Flyway 3.1 milestone Oct 16, 2014
@axelfontaine axelfontaine added this to the Flyway 4.0 milestone Mar 5, 2015
@axelfontaine axelfontaine removed this from the Flyway 3.2 milestone Mar 5, 2015
@axelfontaine axelfontaine added this to the Flyway 4.1 milestone Dec 30, 2015
@axelfontaine axelfontaine removed this from the Flyway 4.0 milestone Dec 30, 2015
@axelfontaine axelfontaine added this to the Flyway 5.0 milestone Feb 6, 2017
@axelfontaine axelfontaine removed this from the Flyway 4.1 milestone Feb 6, 2017
@axelfontaine axelfontaine removed this from the Flyway 5.0.0 milestone Nov 26, 2017
@axelfontaine axelfontaine added this to the Flyway 5.1.0 milestone Nov 26, 2017
@axelfontaine axelfontaine changed the title batch updates of SQL patches Batch updates for SQL statements Apr 10, 2018
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Apr 10, 2018
@Spacefreak18
Copy link

@Spacefreak18 Spacefreak18 commented Aug 30, 2018

Is this a definite as far as not going to implement?

It would be very useful for my workflow as it depends on callbacks which bootstrap and configure the database. These statements are written in an idempotent manner. I have had to do workarounds to get these idempotent statements to work through flyway, because the statements are not executed in a batch manner.

Loading

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Aug 30, 2018

@Zitz This has been implemented and is available today as part of Flyway Pro and Enterprise Edition.

Loading

dohrayme pushed a commit to dohrayme/flyway that referenced this issue Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants