Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Performance SPARQL Queries #7

Open
retog opened this issue Feb 16, 2020 · 5 comments
Open

Performance SPARQL Queries #7

retog opened this issue Feb 16, 2020 · 5 comments
Assignees
Labels

Comments

@retog
Copy link
Collaborator

retog commented Feb 16, 2020

Investigate long query response time

@retog
Copy link
Collaborator Author

retog commented Apr 22, 2020

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
Copy link
Collaborator Author

retog commented Apr 22, 2020

Query 1:

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

Query 1.1

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

@retog
Copy link
Collaborator Author

retog commented Apr 23, 2020

Allegro after optimizing repository:

  • first 112ms then 9ms, 11ms

Query 1.1: ~1.5s

@retog
Copy link
Collaborator Author

retog commented Apr 24, 2020

day after (after update)

  • first 116 then 34,38m

@retog
Copy link
Collaborator Author

retog commented May 19, 2020

25 days later after optimization

  • fisrt ~200 then ~45ms

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant