- 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
Slow query
Essentially two tables were utf8 (= utf8mb3). The others are utf8mb4. When comparing text fields mariadb can't optimize because it is translating utf8mb3 for every comparison. Changing...
- 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...
- 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...
- GN1 annotation page broken
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Dec 17 2022 by Pjotr Prins; 0 of 2 tasks done
.../rubo77/php-mysql-fix/blob/master/fix_mysql.inc.php
that gets included with
```
include_once('../includes/fix_mysql.inc.php')
```
At the final step we have to fix CKEDITOR
## CKEDITOR
FF console says...