Hi,
sometimes when I execute queries the sparql endpoint returns this error:
Virtuoso 42000 Error SQ200: The memory pool size 80019456 reached the limit
80000000 bytes, try to increase the MaxMemPoolSize ini setting.
SPARQL query:
define sql:big-data-const 0
#output-format:text/html
define sql:signal-void-variables 1 define input:default-graph-uri
<http://dbpedia.org> PREFIX : <http://dbpedia.org/resource/>
PREFIX dbp: <http://dbpedia.org/ontology/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wgs: <http://www.w3.org/2003/01/geo/wgs84_pos#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT DISTINCT ?label ?sub ?date ?place ?lat ?lon
WHERE {
?sub rdf:type dbp:Film;
rdfs:label ?label;
?pred_place ?place;
dbp:releaseDate ?date;
dbp:country ?place.
?place rdf:type ?class ;
wgs:lat ?lat ;
wgs:long ?lon.
?class rdfs:subClassOf* dbp:PopulatedPlace .
FILTER ( ?date >= '1940-01-01'^^xsd:date && ?date <= "1944-01-01"^^xsd:date )
FILTER ( ?lat >= "36.650829"^^xsd:float && ?lat <= "47.090542"^^xsd:float &&
?lon <= "18.51083"^^xsd:float && ?lon >= "6.620172"^^xsd:float )
FILTER ( langMatches(lang(?label), "EN"))
}
ORDER BY ASC(?date)
the strange thing is that the error is returned only for specific ontology
category. For example "Film" in the above query but also "Book" and "Single".
Someone has already fix this problem? Maybe writing the query in a more
efficient way?
Thanks in advance
Fabio------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. A cloud service to automate IT design, transition and operations
2. Dashboards that offer high-level views of enterprise services
3. A single system of record for all IT processes
http://p.sf.net/sfu/servicenow-d2d-j
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
