是否应该进行读取查询交易？ [英] Should there be a Transaction for Read Queries?

问题描述

我一直在阅读，一些开发人员/ dbas建议在所有数据库调用（甚至只读调用）中使用事务。虽然我了解在事务中插入/更新事务，但在事务中进行读取有什么好处？

I've been reading that some devs/dbas recommend using transactions in all database calls, even read-only calls. While I understand inserting/updating within a transaction what is the benefit of reading within a transaction?

推荐答案

因此，您可以获得一致的看法数据库。假设您有两个相互链接的表，但是由于某种原因，您在pseuodocode中做了2个选择...

So you get a consistent view of the database. Imagine you have two tables that link to each other, but for some reason you do 2 selects... in pseuodocode:

myRows = query(SELECT * FROM A)
moreRows = query(SELECT * FROM B WHERE a_id IN myRows[id])

如果在两个查询之间，有人更改B以删除某些行，那么您将遇到问题。

If between the two queries, someone changes B to delete some rows, you're going to have a problem.

这篇关于是否应该进行读取查询交易？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！