When parsing a large production model some high level concepts we want to filter on are structured as assets. I.e. a fiscal region for power in the Statnett case.
Our model is now hitting limitations of subtree queries. With more than 100k assets per region for some regions. What is your thinking around how to handle such cases in a model?
To spike the conversation we’ve considered moving high-concept parts of the tree to labels, or making more of the DB type of operations locally.
However, the former demands a pipeline for moving concepts suited for a tree to a Label “just because”. The latter requires quite a lot of iron present on the local instance processing the query.
An instance of the SDK quering we do can be seen in the power-SDK in github.