Thursday, 15 May 2014

postgresql - Does the "increment" feature in Sequelize scale well? -



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