- Slow query
issue opened on May 27 2023 by Pjotr Prins, last updated on May 29 2023 by Pjotr Prins; 0 of 2 tasks done
...query.
## Indices
ProbeSet has a large number of columns, indices and full text indices(!)
## Nailing it down
The obvious thing to try is to reduce the query and see what speeds it up again. So, let's...
- Slow query
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi
Slow query
## Tags
* assigned: Uditgulati
* priority: high
* status: stalled
* keywords: slow query, from github
## Description
=> https://github.com/genenetwork/genenetwork2/issues/419 From GitHub...
- Variant Browser seems to be using mm9
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...do not match the query.
Searching for a gene gives correct coordinates in the search box at http://www.genenetwork.org/snp_browser, but the results are for the same coordinates in mm9 (see screenshot).
- Global search does not close connections properly (and is slow)
✓ issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Oct 14 2022 by Arun Isaac
...[Warning] Aborted connection 45219 to db: 'db_webqtl' user: 'webqtlout' host: '127.0.0.1' (CLOSE_CONNECTION)
```
generating 6Mb of log file info.
In fact, every row in the table has a SQL query...
- Fetch trait names for phenotypes
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
.../564 From GitHub
The 'Fetch Trait Info' query returns detailed information for transcript expression traits, but not for traits from the 'Publish' database.
### Describe the solution you'd like
For...