diff options
| author | Frederick Muriuki Muriithi | 2022-10-21 11:34:35 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-10-21 11:35:01 +0300 |
| commit | 4d6d7d5002f31001af9b7bc6edced7be69b82e8f (patch) | |
| tree | 19bf5e021a88a4087420a5da8eecdb59297ae88f | |
| parent | 4bd7e5036bef5f931f9b639dee8708f288ec27d1 (diff) | |
| download | gn-gemtext-4d6d7d5002f31001af9b7bc6edced7be69b82e8f.tar.gz | |
Issues (do-bulk-query-for-correlation-results-display): New issue
| -rw-r--r-- | issues/do-bulk-query-for-correlation-results-display.gmi | 16 |
1 files changed, 16 insertions, 0 deletions
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. |