Performance optimisation with Composite Index

[scwall]

UPDATE/INFORMATION

After the creation of a compound index I saw my performance greatly implied for the cost of a slightly slower insertion due to the reconstruction of the index but considering the size of the nested data I am a big winner in terms of performance: Index

$table->index(['id', 'lft', 'rgt']);