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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kieron Taylor Sent: Wednesday, August 20, 2008 4:35 PM To: [email protected] 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 [email protected] http://lists.librdf.org/mailman/listinfo/redland-dev _______________________________________________ redland-dev mailing list [email protected] http://lists.librdf.org/mailman/listinfo/redland-dev
