https://we.phorge.it/source/phorge/browse/master/src/applications/maniphest/controller/ManiphestReportController.php$87-121 is the only place in upstream which queries the ManiphestTransaction table:
$table = new ManiphestTransaction();
$conn = $table->establishConnection('r');
[...]
$data = queryfx_all(
[...]
$table->getTableName(),This is getting more and more expensive in our installation so I already had to adjust some other custom downstream code querying this table.[1],[2]
As I wrote in T119376#9833809,
in the long term, I expect the upstream report/chart code to break anyway due to timeouts, given the current database structure.
Upstream code should likely be ported to use something similar to a Materialized View, cf https://dba.stackexchange.com/questions/86790/best-way-to-create-a-materialized-view-in-mysql