This is triggered by hook_entity_load() so runs a lot.

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	et	range	PRIMARY,revision_id	PRIMARY	390		1655	Using where; Using filesort
CommentFileSizeAuthor
#1 entity_translation_2458393.patch565 bytescatch
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

catch’s picture

catch
he/him
Primary language English
CreditAttribution: catch commented
Status: Active » Needs review
FileSize
entity_translation_2458393.patch565 bytes

Tried a couple of indexes but neither actually gets rid of the filesort. Then I thought about it and checked with plach, and we could just remove the ORDER BY instead.

plach’s picture

plach
he/him
Primary language Italian
Location Venezia
CreditAttribution: plach commented

Looks good to me, please RTBC when tested enough.

douggreen’s picture

douggreen CreditAttribution: douggreen commented
Status: Needs review » Reviewed & tested by the community
plach’s picture

plach
he/him
Primary language Italian
Location Venezia
CreditAttribution: plach at Tag1 Consulting commented

Committed and pushed, thanks.

  • catch authored 234aa1f on 7.x-1.x 
    Issue #2458393 by catch, plach, douggreen: Fixed unindexed query in...
plach’s picture

plach
he/him
Primary language Italian
Location Venezia
CreditAttribution: plach at Tag1 Consulting commented
Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.