postgresql - Does the "increment" feature in Sequelize scale well? -
i'm investigating scalibility of sequalize in production app, increment
function, see how can handle when row theortically updated several times simultaneously (say, totals row of something). question can sequalize increment
operator trusted these little add-on operations concurrent?
we're using postgres on backend, i'm not familar internals of postgres , how handle type of scenerio (heroku postgres production host, if matters).
the docs / the code
the sql ran sequealize according code comments
set column = column + x
it's hard without finish sql examples, i'd serialize transactions phone call on same object.
if update object, db takes row update lock that's released @ commit/rollback time. other updates/deletes block on lock until first tx commits or rolls back.
postgresql heroku sequelize.js
No comments:
Post a Comment