Re: [Virtuoso-users] Which indexes could help to improve query performance.

Hi Martin, To eliminate the time to retrieve the result set do a 'sparql select count(*) where ( ... ) ' , this would give us the time to execute query server side. The rest is transmitting results to client, should see difference. Best Regards, Mitko On Apr 22, 2010, at 7:24 PM, Martin Gerl

Re: [Virtuoso-users] Which indexes could help to improve query performance.

Hi Mitko, I executed the query many times with no notable improvement of response time. We are not using striped setup. I rebooted Virtuoso, checked the stats, ran the query and re-checked the stats. Onle the RDF_QUAD (primary key?) and RDF_QUAD_POGS indexes seem to be used, see below. Cheers,

Re: [Virtuoso-users] Which indexes could help to improve query performance.

Hi Martin, From the statistics i seem to me the db cache is not warmed, the disk cache is cold as only couple of disk buffers are used. What happens if you run query few more times ? you should see difference with execution time, how is it compared agains first run. If still time large, can ch

Re: [Virtuoso-users] Which indexes could help to improve query performance.

Hi Kingsley, thanks for your reply. We are not working on the DBPedia dataset, but are currently evaluating different models for metadata storage with a constructed set of test data. We are only using some of the DBPedia concepts and properties. However, I could try to adapt the query to DBPedia

Re: [Virtuoso-users] Which indexes could help to improve query performance.

Hi Mitko, The exact query is: sparql select ?conflict ?dateBegin where { ?conflict a ; ?p . ?p rdfs:subPropertyOf rdf:type ; ?dateBegin . } EXPLAIN gives me this... do yo

Re: [Virtuoso-users] Which indexes could help to improve query performance.

Mitko Iliev wrote: Hi Martin, The default indexes should do, i don't see wrong plan or similar. So it's better to send us the execution plan so we can see how this query compiles on your site; to do this put the query in explain ('sparql ...query here ..') and execute via command line ISQL tool

Re: [Virtuoso-users] Which indexes could help to improve query performance.

Hi Martin, The default indexes should do, i don't see wrong plan or similar. So it's better to send us the execution plan so we can see how this query compiles on your site; to do this put the query in explain ('sparql ...query here ..') and execute via command line ISQL tool. When doing expl

[Virtuoso-users] Which indexes could help to improve query performance.

Hi, The following SPARQL Query returns approx. 1 results out of 35 million triples. select [distinct] ?conflict ?metadata [from ] where { ?conflict a . ?conflict ?p . ?p rdfs:s