ColdBox Platform › [coldbox-5.6.2] [cborm-2.50] - Performance impact from creating thousands of records using entity one to many relationship

I have a one to many relationship in my application.

Product.cfc entity has many ProductUser records.

I have a IDProduct in the ProductUser entity and I will need to add hundreds or perhaps thousands of records to that table.

Using orm I will be bring back my Product entity instance and then add each ProductUser to it by calling the addProductUser on the Product entity to add it.

Once I have completed adding all my ProductUser I will then save my Product entity.

My concern is that there will be a performance hit compared with using a SQL Insert statement to all my ProductUser records directly in the database.