Comments (5)
Also note that very restrictive queries seem to cause huge execution time estimates:
select * where { ?s ?p ?o. VALUES (?s) { (dbpedia:Berlin) (dbpedia:Kaiserslautern) } VALUES (?p) { (rdfs:label) (skos:refLabel) } }
Virtuoso 42000 Error The estimated execution time 82966 (sec) exceeds the limit of 3000 (sec).
from virtuoso-opensource.
We will be looking into this shortly.
from virtuoso-opensource.
As a workaround, putting the VALUES statement at the top of the query body seems to execute much faster.
barcou@deri$ echo "SELECT * WHERE { VALUES (?uri) { (dbpedia:Berlin) (dbpedia:Kaiserslautern) } . ?uri rdfs:label ?label. }" > /tmp/b
barcou@deri$ time curl "http://dbpedia.org/sparql" --form "query=@/tmp/b"
<snip>
real 0m1.477s
<snip>
barcou@deri$ echo "SELECT * WHERE { ?uri rdfs:label ?label. VALUES (?uri) { (dbpedia:Berlin) (dbpedia:Kaiserslautern) } }" > /tmp/a
barcou@deri$ time curl "http://dbpedia.org/sparql" --form "query=@/tmp/a"
... 504 gateway timeout after 10 mins
from virtuoso-opensource.
@bcoughlan cool, thanks for the hint
from virtuoso-opensource.
Some more investigation... with SPARQL DELETE, VALUES is also extremely slow and the workaround I mentioned above does not work.
Example:
Time: 15.08 seconds
DELETE {
GRAPH <http://example.com/> { ?node ?p ?o . }
} WHERE {
GRAPH <http://example.com/> {
VALUES ?node { :a :b :c :d :e :f :g :h :i }
?node ?p ?o .
}
}
Running them as separate queries (i.e. run with :a ?p ?o
:b ?p ?o
and so on) takes a total 0.082 seconds on my machine. A huge difference that only gets worse with more VALUES.
Another observation: This seems to depend on the amount of data already in the store, there is no difference between the two when the nodes the store has little or no data in it.
from virtuoso-opensource.
Related Issues (20)
- Query returns nothing in group graph HOT 2
- Slow performance on `GRAPH_GROUP` HOT 6
- Assertion 'n->n_neg == 0 || !num_is_zero (n)' failed when compiled with --with-debug HOT 1
- Virtuoso 7.2.12 stack overflows at `compile_regex` HOT 1
- Virtuoso 7.2.12 crashes at `virtpcre_exec` HOT 1
- Virtuoso 7.2.12 crashes with the REPEAT function
- Virtuoso 7.2.12 crashes at `dk_alloc_box`
- Virtuoso 7.2.12 crashes at `dk_free_tree`
- Virtuoso 7.2.12 crashes at `dc_append_bytes`
- Virtuoso 7.2.12 crashes with the `COMPOSITE` function
- Virtuoso 7.2.12 crashes with the `MD5_FINAL` function
- Virtuoso 7.2.12 crashes with the `ROWVECTOR_DIGIT_SORT` function
- Virtuoso 7.2.12 crashes with the `SOAP_CALL` function
- Virtuoso 7.2.12 crashes with the `SOAP_CLIENT` function
- Virtuoso 7.2.12 crashes with the `XENC_GET_KEY_ALGO` function HOT 1
- Virtuoso 7.2.12 crashes with the `XMLATTRIBUTES` function HOT 2
- Virtuoso 7.2.12 crashes with the `XPF_EXTENSION` function
- Several DBA functions can cause the server crash
- Virtuoso 7.2.12 crashes with the `XTE_NODEBLD_ACC` function
- problem with the macOS installer HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from virtuoso-opensource.