Sorry for the late response > Paul, > On 11 Apr 2008, at 19:46, Paul Kreis wrote: > > > Hi All, > > > > I have still three problems: > > > > #1: always i test that query[1] on the DBpedia SPARQL-Endpoint > > (http://DBpedia.org/sparql) i get this: "..... Error SQ200: The memory > > pool size 10518528 reached the limit 10485760 bytes, try to > > increase the > > MaxMemPoolSize ini setting." > > If i simplify the query and leave out the part with the director or > > the > > producer, it works. > > [Hugh] The MaxMemPoolSize for the DBpedia SPARQL Endpoint has been > doubled, and I can now run query #1 although it does return an empty > result set. Please re-run yourself ... > [Paul] Thanks! > > > > #2: some of my queries[2] are still to slow, it takes to much time for > > the results, or i run in the maximum execution time. > > [Hugh] I have been able to run query #2, so this may have benefited > from the MaxMemPoolSize increase. Please re-run yourself ...
[Paul] I think the speed has nothing to do with the MaxMemPoolSize. It is still very slow. Maybe you can run the query with other citys (e.g. Hamburg, New York, it's slow too) because the server cashs the results and it takes only a few seconds if someone has run the query with the same city before. > > > > #3: whenever i use bif:contains in a query[3] and there is a blank > > (e.g. > > ?cityname bif:contains "New York") in the searchstring, i get this > > error: "37000 Error XM029: Free-text expression, line 1: syntax > > error at > > York" > > [Hugh] You should use ?cityname bif:contains "'New York'" , note the > single quotes inside the double quotes , which worked for me. Please > re-run yourself ... > [Paul] That one was simple :-) Thanks a lot Paul Kreis > Best Regards > Hugh Williams > Professional Services > OpenLink Software > > > > > best regards, > > Paul Kreis > > > > Queries: > > [1] > > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > > PREFIX dbpedia2: <http://dbpedia.org/property/> > > SELECT DISTINCT ?filmname ?page > > FROM <http://dbpedia.org> > > WHERE { > > ?film dbpedia2:name ?filmname . > > ?film foaf:page ?page . > > {?film ?property > > <http://dbpedia.org/class/yago/MotionPictureFilm103789400>} OPTIONAL > > {?film ?property <http://dbpedia.org/class/yago/Film106613686>} > > {?film dbpedia2:director ?director . ?director foaf:name ? > > directorname . > > ?directorname bif:contains "Kennedy"} > > {?film dbpedia2:producer ?producer . ?producer foaf:name ? > > producername . > > ?producername bif:contains "Spielberg"} > > {?film dbpedia2:year ?year }UNION{?film dbpedia2:years ?year } FILTER > > (?year > "2000"^^xsd:integer) } > > ORDER BY ?filmname > > > > [2] > > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > > PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> > > SELECT DISTINCT ?cityname ?lat ?long ?page > > FROM <http://dbpedia.org> > > WHERE { > > { ?city ?property <http://dbpedia.org/class/yago/City108524735> } > > UNION { ?city ?property <http://dbpedia.org/class/yago/ > > Capital108518505> } > > UNION { ?city ?property <http://dbpedia.org/class/yago/ > > Town108665504> } > > ?city rdfs:label ?cityname . > > FILTER (LANG(?cityname) = "en") . > > ?city geo:long ?long . > > ?city geo:lat ?lat . > > ?city foaf:page ?page . > > ?cityname bif:contains "Berlin" . } > > ORDER BY ?cityname > > > > [3] > > PREFIX foaf: <http://xmlns.com/foaf/0.1/> > > PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> > > PREFIX geo: <http://www.w3.org/2003/01/geo/wgs84_pos#> > > SELECT DISTINCT ?cityname ?page > > FROM <http://dbpedia.org> > > WHERE { > > { ?city ?property <http://dbpedia.org/class/yago/City108524735> } > > UNION { ?city ?property <http://dbpedia.org/class/yago/ > > Capital108518505> } > > UNION { ?city ?property <http://dbpedia.org/class/yago/ > > Town108665504> } > > ?city rdfs:label ?cityname . > > FILTER (LANG(?cityname) = "en") . > > ?city foaf:page ?page . > > ?cityname bif:contains "New York" . } > > ORDER BY ?cityname > > > > ---------------------------------------------------------------------- > > --- > > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > > Don't miss this year's exciting event. There's still time to save > > $100. > > Use priority code J8TL2D2. > > http://ad.doubleclick.net/clk;198757673;13503038;p?http:// > > java.sun.com/javaone > > _______________________________________________ > > Dbpedia-discussion mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Dbpedia-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
