Given that the website contains 4k translatable entities (nodes). Some times the node view page goes timeout.
Devel queries logger shows a huge query execution on table {entity_translation}. So i guess this is why its timing out.
As i understand {entity_translation} is used to track translated entities, but why its reading the whole table on entity view page?
Is it normal?

Comments

fadi.assaad created an issue.

joel_osc’s picture

joel_osc CreditAttribution: joel_osc at OpenPlus commented

I recently ran into an issue where none of my views that used the entity_translation relationship would work on a large database. They would just spin forever... I am not sure this is what you are seeing but if it is it is fixed in the latest version of entity_translation. Refer to #2572203: Wrong query generated when several Translations relationships are used for more info.