Faster way to find duplicates in data table?

[ianb]

@owen.campbell I was told by others that the transaction blocks do not work like that and only do validation / rollback for atomicity.

'Delete' (None) all rows in a column

This is not my understanding of how anvils in_transaction blocks work. As I understand it, really the only thing the in_transaction block does is open and close a transaction for you as your function is entered/exited, such that if the function throws an error at any point the entire transaction is rolled back (so you don’t end up with partially committed changes). It also makes sure that multiple concurrent database calls that might affect the same rows will not overlap. However, it does NOT co…

Do you know if the above quote is incorrect and it is actually the way you (and I who assumed the same previously) think it works?

I don’t think I could ever find out a concrete answer to this.