Many thanks, Andy. Indeed.
Also within 1 second now. My assumption was that a subquery always is evaluated first with results moving up to the higher parts? Paul On 21 February 2018 at 13:12:06, Andy Seaborne ([email protected]<mailto:[email protected]>) wrote: Hi Paul, The difference between the two queries is initial "?item schema:about ?cbbObject." in the second one. If you reverse the order of SERVICE and local pattern match, you may get better execution. { ?item schema:about ?cbbObject. {SELECT ?cbbObject ?cbbnr ?cbbObjectType ?cbbNaam ... } } ==> { {SELECT ?cbbObject ?cbbnr ?cbbObjectType ?cbbNaam ... } ?item schema:about ?cbbObject. } Please let the list know if this helps, Andy On 21/02/18 08:30, Paul Hermans wrote: > Using Fuseki 3.6.0 and also Fuseki 3.4.0 with TDB backend. > > Query 1 returns 1 result immediately > > PREFIX dct: <http://purl.org/dc/terms/> > PREFIX schema: <http://schema.org/> > PREFIX prov: <http://www.w3.org/ns/prov#> > PREFIX dc: <http://purl.org/dc/elements/1.1/> > PREFIX skos: <http://www.w3.org/2004/02/skos/core#> > SELECT ?cbbObject ?cbbnr ?cbbObjectType ?cbbNaam > WHERE { > SERVICE <xxx> { > VALUES ?cbbnr {'00418870043670'} > ?cbbObject a ?cbbObjectType; > <http://www.w3.org/2000/01/rdf-schema#label> ?cbbNaam ; > dct:identifier ?cbbnr . }} > > > > Query 2 with the previous as a subselect runs forever. > > PREFIX dct: <http://purl.org/dc/terms/> > PREFIX schema: <http://schema.org/> > PREFIX prov: <http://www.w3.org/ns/prov#> > PREFIX dc: <http://purl.org/dc/elements/1.1/> > PREFIX skos: <http://www.w3.org/2004/02/skos/core#> > SELECT * > WHERE > { ?item schema:about ?cbbObject. > {SELECT ?cbbObject ?cbbnr ?cbbObjectType ?cbbNaam > WHERE { > SERVICE <http://lodcbbomv-on-1.vm.cumuli.be:8080/lodomv/repositories/cbb> { > VALUES ?cbbnr {'00418870043670'} > ?cbbObject a ?cbbObjectType; > <http://www.w3.org/2000/01/rdf-schema#label> ?cbbNaam ; > dct:identifier ?cbbnr . }}}} > LIMIT 1 > > The same query in Virtuoso and Stardog returns a result within 1 sec. > > What am I missing? > > > Kind Regards, > Paul Hermans > Kind Regards, Paul Hermans ------------------------- ProXML bvba Linked Data services KBO: http://data.kbodata.be/organisation/0476_068_080#id (w) www.proxml.be<http://www.proxml.be/> (e) [email protected]<mailto:[email protected]> (tw) @PaulZH (t) +32 15 23 00 76<tel://+32%2015%2023%2000%2076> (m) +32 473 66 03 20<tel://+32%20473%2066%2003%2020> Narcisweg 17 3140 Keerbergen Belgium ODEdu – Innovative Open Data Education and Training based on PBL and Learning Analytics - http://odedu-project.eu/ OpenGovIntelligence – Public Administration Modernization by exploiting Linked Open Statistical Data - http://www.opengovintelligence.eu<http://www.opengovintelligence.eu/> OpenCube – Linked Open Statistical Data - http://opencube-project.eu/
