Big transactions

[heinrichhanekom]

Hi
Is there an option to use update_all instead of single transactions?
This can become an real issue for some resources. Consider the following:
An organisation can have many profiles (lets say 10). Every profile has many trackings (1 a day for 3 years = 1095 )
When you archive the organisation it would create 1 + 10 + (10*1095) = 10.961 queries.
Thats kind of a lot.
Thanks

[janxious]

Not currently, but we would accept a patch. IIRC we didn't do bulk changes initially due to the data required to archive something being difficult to get at efficiently and generically when we wrote this gem (late rails 2 era). I suspect with Arel and some hard thinking it is doable now.