Store computed relations into materialized view
computed relations: https://cubicweb.readthedocs.io/en/3.30.0/book/devrepo/datamodel/definition/#using-computed-attributes-and-relations
In my opinion, it could be a good things to use materialize views in order to facilitate access to these relations and improve performances
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information