- 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
...in progress
* keywords: slow query
# Tasks
* [ ] upgrade mariadb on production
* [ ] switch character type on ProbeSet table from latin1/utf8mb3 to utf8mb4 (and any other tables) - depends on mariadb...
- 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...
- 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
Global search does not close connections properly (and is slow)
## Tags
* type: bug
* priority: medium
* status: stalled
* assigned: Uditgulati
* keywords: global search, db connections, medium...
- Search results for SNP looks weird
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Oct 12 2022 by Munyoki Kilyungi
...progress
* keywords: UI, SNP, from github
## Description
=> https://github.com/genenetwork/genenetwork2/issues/395
### Description
After an update using the latest datatables from GUIX from
=> https...
- 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).
- 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...