has_and_belongs_to_many

[chumakoff]

Whenever I update a main record, versions for hundreds associated through 'has_and_belongs_to_many' records are created.
Is that an expected behavior?

class AnyModel < ApplicationRecord
  has_and_belongs_to_many :any_associations
end

record = AnyModel.last
record.any_associations.count # => 999999999999
record.touch  # this will result in 99999999999 "INSERT INTO `version_associations" SQL queries

[westonganger]

Yes this is probably what we are forced to do with HABTM relationships. I wouldnt recommend using HABTM relationships ever really, try using a has_many through relationship

Alternatively depending on the use case it may be an idea to add has_paper_trail only: [:revision_number] or something on the parent model to limit the number of version records created.