diff options
Diffstat (limited to 'issues/handling-resource-links-in-probeset-page.gmi')
-rw-r--r-- | issues/handling-resource-links-in-probeset-page.gmi | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/issues/handling-resource-links-in-probeset-page.gmi b/issues/handling-resource-links-in-probeset-page.gmi index bcd50ed..2f18c19 100644 --- a/issues/handling-resource-links-in-probeset-page.gmi +++ b/issues/handling-resource-links-in-probeset-page.gmi @@ -55,3 +55,18 @@ Identifying duplicates: ``` SELECT GeneSymbol, GeneId, SpeciesId, COUNT(CONCAT(GeneSymbol, "_", GeneId, "_", SpeciesId)) AS `count` FROM GeneList GROUP BY BINARY GeneSymbol, GeneId, chromosome, txStart, txEnd HAVING COUNT(CONCAT(GeneSymbol, "_", GeneId, "_", SpeciesId)) > 1; ``` + +Transforming ProbeSet metadata takes long. The exact command: + +```shell +time guix shell guile-dbi \ +guile-hashing -m manifest.scm -- ./pre-inst-env ./examples/probeset.scm --settings conn.scm --output /export/data/genenetwork-virtuoso/probeset-metadata.ttl --documentation ./docs/probeset-metadata.md +``` + +The aforementioned command takes: + +* real: 89m1.715s +* user: 175m47.684s +* sys: 6m15.076s + +Optimisations---perhaps using guile-fibers---can be considered later. |