- 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...
- csv export meta data are not commented out
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...py?FormID=sharinginfo&InfoPageName=BXDPublish
Name,Value,SE,N
BXD1,3125.333,803.776,6
BXD2,540.167,448.724,6
```
The metadata need to be commented out and the empty line needs to be removed. R expects...
- 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
...5.1.6 (cli) (built: Mar 18 2014 20:48:55)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
In guix-bioinformatics we have
```
php 5.6.40 out...
- Capture Data on the BXDs in RDF
✓ issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Oct 12 2022 by Munyoki Kilyungi
...an ontology exists and it looks sensible we should reuse that. If non-existent, we create our own ontology. Obviously we can't get away from adding free flow textual fields. What we want to lift out...
- BXD102xBXD077F1 Error
✓ issue opened on Mar 22 2022 by Frederick Muriuki Muriithi, last updated on Apr 07 2022 by Zachary Sloan
...trait_id=1448231_at&dataset=HC_M2_0606_P
>
> jacs123
I (fredm) tried this out, and it seems there is still an issue here.
This appears to no longer be an issue; it was probably addressed along...