Performance SPARQL Queries

[retog]

Investigate long query response time

[retog]

query 1:

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX dwc: <http://rs.tdwg.org/dwc/terms/>
PREFIX dwcfp: <http://filteredpush.org/ontologies/oa/dwcFP#>
PREFIX tp: <https://vocab.plazi.org/taxomplete/>
SELECT DISTINCT ?genus ?species WHERE {
  ?sub dwc:genus ?genus .
  ?sub dwc:species ?species .
  ?sub rdf:type dwcfp:TaxonName.
  ?sub tp:speciesPrefix4 "sada".
  FILTER REGEX(?species, "^Sada","i")
} ORDER BY UCASE(?species) LIMIT 10

query 1.1

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX dwc: <http://rs.tdwg.org/dwc/terms/>
PREFIX dwcfp: <http://filteredpush.org/ontologies/oa/dwcFP#>
PREFIX tp: <https://vocab.plazi.org/taxomplete/>
SELECT DISTINCT ?genus ?species WHERE {
  ?sub dwc:genus ?genus .
  ?sub dwc:species ?species .
  ?sub rdf:type dwcfp:TaxonName.
  FILTER REGEX(?species, "^Sada","i")
} ORDER BY UCASE(?species) LIMIT 10

[retog]

Query 1:

• Allegro 300-614ms
• Stardog first 91ms, then ~30ms

Query 1.1

• Allegro ~3200ms
• Stardog first 2286ms, then 2946, ~700

[retog]

Allegro after optimizing repository:

• first 112ms then 9ms, 11ms

Query 1.1: ~1.5s

[retog]

day after (after update)

• first 116 then 34,38m

[retog]

25 days later after optimization

• fisrt ~200 then ~45ms