- 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
...caches every data page and index page (and its grandmother) it touches. If your InnoDB Buffer Pool is too small, you could be caching pages, invalidating pages, and removing pages all in one query.
I...
- 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...
- GN1 annotation page broken
issue opened on Dec 23 2022 by Pjotr Prins
.../421 From GitHub
=> http://gn1.genenetwork.org/webqtl/main.py?FormID=annotation The annotations page in GN1
is broken. An exception stack trace is displayed, instead of the annotations page content.
- 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
...page in GN1
is broken. An exception stack trace is displayed, instead of the annotations page content.
## Info
Lily runs a PHP from 2006(!)
PHP 5.1.6 (cli) (built: Mar 18 2014 20:48:55)
Copyright (c)...
- 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...
- 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
...-page Add Metadata To The Trait Page (RDF)
This is currently being worked on in:
=> issues/add-metadata-to-traits-page Annotate traits page with metadata from RDF
Work on dumping RDF has already been...