- 🇫🇷France nicolas bouteille
Just wanted to add some experience feedback here.
I have 1.5 million records of an ECK Entity with 4 custom classic fields + 2 base fields (title and created). So data is stored in 6 tables.
I have 2 million records of a custom entity with 9 base fields all stored in only 1 table.I am receiving MySQL transaction deadlock errors sometimes when writing as few as two records at the same time for the ECK Entity, which makes sense because Drupal needs to use MySQL Transaction in order to ensure data consistency between those 6 tables.
On the other hand, my custom entity with 2 million records never crashes since it only writes records in one table.