I have this pretty expensive query below wich i try to run on dbpedia.org/sparq
endpoint. (I run it just for testing, I ultimately want to use it in PHP with
parameters) The problem is it works only in the morning (USA time) and at night
(USA Time). It doesn't work at normal hours. I get a "Virtuoso: Transaction
timeout".
I understand this is a limitation that DBPedia as put to not overload their
system, wich is limited anyway.
If I put a "LIMIT 1" i still get the transaction timeout error.
Maybe I can contact DBPedia and have them increase the time alloted for a
query. It doesn't run for merely 1-2 seconds until i already get the error. Any
help or sugestions are appreciated.
PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX : <http://dbpedia.org/resource/>
PREFIX dbpedia2: <http://dbpedia.org/property/>
PREFIX dbpedia: <http://dbpedia.org/>
PREFIX ont: <http://dbpedia.org/ontology/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT ?name ?date (bif:substring(STR(?date), 1, 4) AS ?year) WHERE {
?person ont:birthDate ?date .
?person foaf:name ?name
. FILTER ( (fn:string-length(STR(?date)) = 10) && (bif:substring(STR(?date),
9, 2) = '05') && (bif:substring(STR(?date), 6, 2) = '02') && (?date >
"1868-01-01"^^xsd:date) && (?date < "2005-01-01"^^xsd:date) )
}
Explanation of the query: I search for people born in a month and a day and
between 1868-2005. The (fn:string-length(STR(?date)) = 10) is to validate that
the date is fully completed.
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
