Hi Paul,
On 02/11/2012 11:57 AM, Paul Rusu wrote:
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.
Actually, I tried your query out and it worked smoothly, and returned
the required results.
If you still face the same timeout problem, you can try to run it on the
live endpoint available at [1], against which I have executed your query
and it worked with no problem.
Hope that helps.
------------------------------------------------------------------------------
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
[1] http://live.dbpedia.org/sparql
--
Kind Regards
Mohamed Morsey
Department of Computer Science
University of Leipzig
------------------------------------------------------------------------------
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
