[redland-dev] What is the expected performance of a sparql Query?

[Lou Sakey]

Here is a copy of the query.

PREFIX lou: <http://ns.lou.com/2007/lou-ns#>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT * WHERE { 
?subject lou:Sex ?p0.
?subject lou:BirthDate ?p1.
<http://ns.lou.com/2007/Friends> fam:Person ?subject.
FILTER ( 
 ( (?p0 = 'Male') && (xsd:dateTime(?p1) <=
xsd:dateTime('2008-01-31T00:00:00')) && (xsd:dateTime(?p1) >=
xsd:dateTime('2008-01-01T00:00:00')) )
) }


It is expected to find all males born in January of 2008.


Some have suggested using an memory storage option. This is not an option
for me since I expect this database to grow to at least 50 million triples.

-----Original Message-----
From: redland-dev-bounces at lists.librdf.org
[mailto:redland-dev-bounces at lists.librdf.org] On Behalf Of Kieron Taylor
Sent: Wednesday, August 20, 2008 4:35 PM
To: redland-dev at lists.librdf.org
Subject: Re: [redland-dev] What is the expected performance of a sparql
Query?

I have queried small triplestores with SPARQL and experienced near 
instantaneous responses. 20,000 should be trivial for in-memory queries. 
I suspect you're doing something slow in your query, rather than there 
being something odd in your data model.

Would you like to post the query?

Kieron


Lou Sakey wrote:
> I have Redland model with 20,000 triples using the Berkeley DB
> storage option.   I am performing a sparql query using
> librdf_new_query() and librdf_query_execute() to search for all
> people that are male and born between two dates.
> 
> There are a total of 500 people in the model.   Each person has a sex
> property and a birthday property (among others).  It took over 8
> minutes for librdf_query_execute() to complete on a dual core 2.16
> GHZ processor with 2 gigabytes of memory.
> 
> Is this the expected behavior?
> 
> Thanks in advance
> 
> Lou
> 
> 



_______________________________________________
redland-dev mailing list
redland-dev at lists.librdf.org
http://lists.librdf.org/mailman/listinfo/redland-dev