Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Thanks Ivan, Out of all the samples, the 4th one in the previous email is the only one I can't find any work around / alternative syntax for (alternative to the second IN), if you do know of any alternate way of doing this in the interim please do let me know :) eg: select distinct ?s ?p ?o WHERE

Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Hello Nathan, I'll inspect what can be improved tonight. Single-element IN differs from "longer" IN because it becomes an equality and then the query is rewritten to, say, select distinct ( as ?s) ?p ?o WHERE { ?p ?o . } so these

Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Further test cases: seems to be tied to the number of arguments inside the in() clause eg: this works: select distinct ?s ?p ?o WHERE { ?s ?p ?o . FILTER( ?s in () ) } this doesn't (occasionally does but is exceptionally slow): select distinct ?s ?p ?o WHERE {

Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Hi Ivan / All, I've checked, checked and checked a hundred+ times; there's definitely a performance issue with *only* the following query (where a,b,c can be any URIs, and where * can be * or ?s ?p ?o ): SELECT * WHERE { ?s ?p ?o . FILTER( ?s in( a,b,c ) ) } I can skirt around the performance

Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Hello Nathan, I've checked the compilation of the query and it seems the same for old and new versions, so I have no clue. I can't say anything about the speed of dbpedia.org endpoint, but it runs Virtuoso Cluster Edition that is not yet released and it has no relation to your local installation.

Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Nathan wrote: > Nathan wrote: >> Hi, >> >> I'm pretty sure that the performance of in() seems to have downgraded >> somewhat with the new 6.1.0.3126 release of virtuoso; I'm struggling to >> run even very simple queries such as the following without them timing >> out, on both my own 6.1 and dbpedi

Re: [Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Nathan wrote: > Hi, > > I'm pretty sure that the performance of in() seems to have downgraded > somewhat with the new 6.1.0.3126 release of virtuoso; I'm struggling to > run even very simple queries such as the following without them timing > out, on both my own 6.1 and dbpedia.org's instance: >

[Virtuoso-users] SPARQL IN() performance issues w/ 6.1

Hi, I'm pretty sure that the performance of in() seems to have downgraded somewhat with the new 6.1.0.3126 release of virtuoso; I'm struggling to run even very simple queries such as the following without them timing out, on both my own 6.1 and dbpedia.org's instance: SELECT * WHERE { ?s ?p ?o .