From 48f1c1feda91d9809406c83569443eedc9ea799e Mon Sep 17 00:00:00 2001 From: Karen Arutyunov Date: Fri, 14 Jul 2023 22:27:02 +0300 Subject: Optimize builds page by discouraging PostgreSQL from using the nested loop join strategy --- mod/mod-package-version-details.cxx | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'mod/mod-package-version-details.cxx') diff --git a/mod/mod-package-version-details.cxx b/mod/mod-package-version-details.cxx index bf592e9..632e2ca 100644 --- a/mod/mod-package-version-details.cxx +++ b/mod/mod-package-version-details.cxx @@ -624,7 +624,7 @@ handle (request& rq, response& rs) dir_path vd (fdd / rd / dir_path (pkg->project.string ()) / - dir_path (pn.string ()) / + dir_path (pn.string ()) / dir_path (sver)); try @@ -799,6 +799,10 @@ handle (request& rq, response& rs) ts += ')'; + // @@ Note that here we also load result logs which we don't need. + // Probably we should invent some table view to only load operation + // names and statuses. + // if (b.state == build_state::built) build_db_->load (b, b.results_section); -- cgit v1.1