about summary refs log tree commit diff
path: root/examples
diff options
context:
space:
mode:
Diffstat (limited to 'examples')
-rwxr-xr-xexamples/probesets-experiment-metadata.scm9
1 files changed, 5 insertions, 4 deletions
diff --git a/examples/probesets-experiment-metadata.scm b/examples/probesets-experiment-metadata.scm
index b2eb93e..d7c0764 100755
--- a/examples/probesets-experiment-metadata.scm
+++ b/examples/probesets-experiment-metadata.scm
@@ -70,10 +70,11 @@
       (name "ProbeSet Experiments Metadata")
       (connection %connection-settings)
       (table-metadata? #f)
-      (total-rows (assoc-ref
-                   (sql-find db "SELECT count(*) AS count from ProbeSetXRef")
-                   "count"))
-      (rows-per-chunk 1000000)
+      ;; Use composite keyset pagination over joined table identifiers.
+      (keyset-pagination? #t)
+      (chunk-key-field '("ProbeSetFreeze.Id" "ProbeSet.Id"))
+      ;; (total-rows 1000000)
+      (rows-per-chunk 10000)
       (prefixes
        '(("dcat:" "<http://www.w3.org/ns/dcat#>")
          ("gn:" "<http://rdf.genenetwork.org/v1/id/>")