From 4d6d7d5002f31001af9b7bc6edced7be69b82e8f Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 21 Oct 2022 11:34:35 +0300
Subject: Issues (do-bulk-query-for-correlation-results-display): New issue

---
 issues/do-bulk-query-for-correlation-results-display.gmi | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)
 create mode 100644 issues/do-bulk-query-for-correlation-results-display.gmi

diff --git a/issues/do-bulk-query-for-correlation-results-display.gmi b/issues/do-bulk-query-for-correlation-results-display.gmi
new file mode 100644
index 0000000..dd8c77e
--- /dev/null
+++ b/issues/do-bulk-query-for-correlation-results-display.gmi
@@ -0,0 +1,16 @@
+# Do Bulk Query for Correlation Results' Display
+
+## Tags
+
+* assigned:
+* priority: high
+* status
+* keywords: correlations, bulk queries, optimisation
+* type: enhancement, optimisation
+
+## Description
+
+=> https://github.com/genenetwork/genenetwork2/blob/6457f7e3516a04e238eeb061db358eea29cd2332/wqflask/wqflask/correlation/show_corr_results.py#L112-L220 This loop
+in lines 118 to 120 (call to `create_trait(...)) queries the database at least once every iteration, which leads to performance issues.
+
+We need to replace this with a single bulk query that gets all the appropriate data and sets up all the expected data.
-- 
cgit v1.2.3