Why History tables are not having Foreign key constraints where Runtime tables has the foreign key constraints?
Its because of lot of frequent CRUD operations in History tables and to improve performance?
To allow different configurations and to keep the tables more flexible, the history tables contain no foreign key constraints.
Do you notice some patterns in the failures?
@Yana Just need to get confirm for these reason why history tables not have FK constraint. That’s it.
Also i think there’s no Parent-child association with history tables. We can insert the record in any order int the tables. Is that correct?
what kind of configurations?
There are no parent child association with the history tables.
1 Like