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