From 52f430388fbaf38dd1681dcc18bbfd1f90639af2 Mon Sep 17 00:00:00 2001
From: zsloan
Date: Mon, 6 Mar 2023 14:05:50 -0600
Subject: Create correlation_speed_issue.gmi

---
 issues/correlation_speed_issue.gmi | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 issues/correlation_speed_issue.gmi

diff --git a/issues/correlation_speed_issue.gmi b/issues/correlation_speed_issue.gmi
new file mode 100644
index 0000000..714646a
--- /dev/null
+++ b/issues/correlation_speed_issue.gmi
@@ -0,0 +1,17 @@
+# Some correlations running very slowly
+
+## Tags
+
+* assigned: zsloan, pjotrp
+* type: bug
+* priority: high
+* status: in-progress
+* keywords: correlations, database
+
+## Description
+
+Some correlations (it specifically seems to be ones done against ProbeSet databases) are running extremely slowly.
+
+After looking into this, the cause seemed to be a specific query*, which leads me to think it might be related to the recent DB changes. All the actual calculations only take a couple seconds, but then this query takes like ~80 seconds.
+
+* https://github.com/genenetwork/genenetwork2/blob/98602d24c64ffafe2c4af150236b72f77709f8de/wqflask/wqflask/correlation/rust_correlation.py#L23-L55
-- 
cgit v1.2.3