diff options
| author | tsauerwein <tobias.sauerwein@camptocamp.com> | 2016-04-11 23:16:17 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2016-06-06 16:22:11 -0400 |
| commit | 528509e1bc41c7fe4e51f7bb550db6343b29e841 (patch) | |
| tree | 61fc75fa4357c8ca1b2e4923acfca1fdb79c30eb /doc | |
| parent | 2860ae6c4927dbbca9316c81ce15cbbb7df49750 (diff) | |
| download | sqlalchemy-528509e1bc41c7fe4e51f7bb550db6343b29e841.tar.gz | |
Add "render_nulls" flag to bulk_insert as optional performance optimization
Currently, ``Session.bulk_insert_mappings`` omits NULL values which
causes it to break up batches of inserts based on which batches
contain NULL and which do not.
By adding this flag, the same columns are rendered in the INSERT
for all rows allowing them to be batched. The downside is that
server-side defaults are omitted.
Doctext-author: Mike Bayer <mike_mp@zzzcomputing.com>
Change-Id: Iec5969304d4bdbf57290b200331bde02254aa3a5
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/243
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/build/changelog/changelog_11.rst | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/build/changelog/changelog_11.rst b/doc/build/changelog/changelog_11.rst index 789a241d0..297be5d2d 100644 --- a/doc/build/changelog/changelog_11.rst +++ b/doc/build/changelog/changelog_11.rst @@ -22,6 +22,15 @@ :version: 1.1.0b1 .. change:: + :tags: feature, orm + + Added new flag :paramref:`.Session.bulk_insert_mappings.render_nulls` + which allows an ORM bulk INSERT to occur with NULL values rendered; + this bypasses server side defaults, however allows all statements + to be formed with the same set of columns, allowing them to be + batched. Pull request courtesy Tobias Sauerwein. + + .. change:: :tags: feature, mssql The ``mssql_clustered`` flag available on :class:`.UniqueConstraint`, |