Paths table is redundant and was slowing down both write
and read path, since it was much harder to simplify it.
It was initially an artefact of having leaves and prefixes
queries, although after optimising the query building,
it's all not required and will allow for faster queries.
Paths table is redundant and was slowing down both write and read path, since it was much harder to simplify it. It was initially an artefact of having leaves and prefixes queries, although after optimising the query building, it's all not required and will allow for faster queries.