Paul, On 25 Apr 2008, at 18:03, Paul Kreis wrote:
> 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. [Hugh] Indeed it is quite slow with the Berlin query taking abt 1min to complete, after which is returned in a few secs having been cached as you said. I ran a query with "London" as the city and took abt 3mins to complete, it even took a few mins when I re-ran it. Perhaps one of the DBpedia/Sparql gurus on the mailing list can comment on how the query can be optimized ??? Regards Hugh > >>> >>> #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
