News for hackers. Stuff that matters.
Re:Salesforce enables ‘modify all’ in user profiles by londons_explore on Saturday May 18, 2019 @03:19AM (#19946183)
Updating every row is usually a bad idea anyway. That means every row needs to be rewritten, which involves reading and writing all data in the table. That will take locks which mean old data needs to be kept (in case of a transaction abort), doubling disk usage. Since half of rows are now dead, all other queries to the table will take double the disk access time.

Basically, if your table is over a few gigabytes, updating every row in one query on a production instance is a really bad plan.

Re:Salesforce enables ‘modify all’ in user profiles by CydeWeys on Saturday May 18, 2019 @10:10AM (#19947445)
So how do you make the change then? Do SQL dialects provide built-in tools to do an UPDATE to a large table in a saner way, or do you end up having to write an application to do so?