nested-set

nested-set copied to clipboard

Optimise the use case where the two conditions overlap in an =

1

There is a special use case where the depth and the start overlap and create SQL that looks like `(a = x)`... this is equivalent to `(a=x)` and as a...

nterbogt

pghaemi

## Problem statement Fetching a parent on a large table can result in a filesort or temporary table before: ``` explain SELECT parent.id, parent.revision_id, parent.left_pos, parent.right_pos, parent.depth FROM nested_set_field_parent_node AS...

larowlan

[node/3251858] Add index for depth.

3

Add index for the subquery generated by the Top relationship. https://www.drupal.org/project/entity_hierarchy/issues/3251858

simesy

To support concurrency, ensure only the node keys are used in transactions. This is an API break.

kimpepper

Adds more indexes

2

Views support in Drupal is using depth and left pos ordering

larowlan

Problem with automated tests, SQLite and Drupal 8

1

Hi there! We're working on a Drupal distribution (LocalGov Drupal) and have had some conversations on https://www.drupal.org/project/dbal/issues/3186378 We're still having problems with our automated tests, which is being discussed on...

finnlewis

This is different from `moveSubTreeBelow` because we don't want to move the parent, just it's children.

kimpepper