diff options
| author | zsloan | 2023-03-06 14:05:50 -0600 |
|---|---|---|
| committer | GitHub | 2023-03-06 14:05:50 -0600 |
| commit | 52f430388fbaf38dd1681dcc18bbfd1f90639af2 (patch) | |
| tree | ed0d12d627d27ab8deb67cee9f91c842313b5920 | |
| parent | 36b447818723ae25d79c3b8250e892ae0fe9af74 (diff) | |
| download | gn-gemtext-52f430388fbaf38dd1681dcc18bbfd1f90639af2.tar.gz | |
Create correlation_speed_issue.gmi
| -rw-r--r-- | issues/correlation_speed_issue.gmi | 17 |
1 files changed, 17 insertions, 0 deletions
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 |