blob: 7f28dd32152f1768e9e538e5299c58779935f9e4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
# Do Bulk Query for Correlation Results' Display
## Tags
* assigned: fredm
* priority: high
* status: closed
* 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.
This new issue has been superseded by
=> /issues/decouple-tasks-in-results-display this one
|
