Re: [Virtuoso-users] Sub-optimal query planning: regex faster than bif:contains

2014-08-20 Thread Hugh Williams
HI Lorenz/Claus, Ah, I see what you mean and have reported to development to look into, as it does appear a bad plan is being selected when the graph name is specified in the query ... SQL> sparql Select ?x { ?x

Re: [Virtuoso-users] Sub-optimal query planning: regex faster than bif:contains

2014-08-19 Thread Lorenz Bühmann
Hello Hugh, if you set the default graph to http://dbpedia.org at http://lod.openlinksw.com/sparql the same behaviour that Claus spotted at DBpedia occurs, which is also strange because it needs much more time on a smaller graph compared to the whole LOd Cloud. Kind regards, Lorenz Hi Cla

Re: [Virtuoso-users] Sub-optimal query planning: regex faster than bif:contains

2014-08-19 Thread Hugh Williams
Hi Claus, I see the behaviour you report running the two queries again http://dbpedia.org/sparql , but running against http://lod.openlinksw.com/sparql the roles are reversed with the bif:contains query completing in about 1 sec : http://lod.openlinksw.com/sparql/?default-graph-uri=&qtxt=Selec

[Virtuoso-users] Sub-optimal query planning: regex faster than bif:contains

2014-08-19 Thread Claus Stadler
Hi, I noticed the following issue on the DBpedia endpoint and the LOD cache (http://dbpedia.org/sparql, http://lod.openlinksw.com/sparql): I did not have time to try it against a develop7 git branch. The following query works as expected and returns fast: It apparently scans the approx. 600 cla