summaryrefslogtreecommitdiff
path: root/issues/handling-resource-links-in-probeset-page.gmi
diff options
context:
space:
mode:
Diffstat (limited to 'issues/handling-resource-links-in-probeset-page.gmi')
-rw-r--r--issues/handling-resource-links-in-probeset-page.gmi15
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.