4 ms·
Do any databases allow you to specify that a transaction needs a particular mode, and then that mode is implemented only for that transaction? e.g., START T
by pak 16y ago
Do any databases allow you to specify that a transaction needs a particular mode, and then that mode is implemented only for that transaction? e.g.,
START TRANSACTION MODE READ REPEATABLE;
or something like that. It would seem to be a way to only use the extra resources when consistency is paramount. Of course it would take a lot of careful thought to determine which transactions need this mode...
- hasanove 16y agoPostgreSQL can do that: http://www.postgresql.org/docs/9.0/static/sql-set-transaction.html http://www.postgresql.org/docs/9.0/static/sql-set-transactio...