Open storborg opened 12 years ago
Currently an update and possibly an insert is issued for every new record persisted in the SQL store. There's probably a performance gain to be had from doing an INSERT ... ON DUPLICATE KEY UPDATE (or for sqlite, INSERT ... ON CONFLICT REPLACE).
INSERT ... ON DUPLICATE KEY UPDATE
INSERT ... ON CONFLICT REPLACE
There are some more tips about making it sqlalchemy-idiomatic here: http://www.sqlalchemy.org/trac/ticket/960
Currently an update and possibly an insert is issued for every new record persisted in the SQL store. There's probably a performance gain to be had from doing an
INSERT ... ON DUPLICATE KEY UPDATE
(or for sqlite,INSERT ... ON CONFLICT REPLACE
).There are some more tips about making it sqlalchemy-idiomatic here: http://www.sqlalchemy.org/trac/ticket/960