Problem/Motivation

entity_reference_revisions_entity_delete does a parent query on allRevisions and it is slow because the index added in ParagraphStorageSchema is not added to the revisions table.

Proposed resolution

Add it.

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Charlie ChX Negyesi created an issue. See original summary.

Ghost of Drupal Past’s picture

Ghost of Drupal Past’s picture

Title: Delete is painfully slow because of a lacking index on the revisions table » parent_fields index is missing from the revisions table
Issue summary: View changes
amateescu’s picture

Added an update function that will add this new index and cleaned up the storage schema a bit because it shouldn't hard-code the table names.

Berdir’s picture

Status: Needs review » Fixed

Thanks! Verified that the update function works as expected.

Status: Fixed » Closed (fixed)

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