Virtuoso performance/Tests

= Queries to use as probes for testing performance of the triple store. =


 * select count(*) from rdf_quad table option (index rdf_quad) - tests raw read speed. Expected: raw read speed/6 in Virtuoso 5 (because of clustered indexes) 2-3x faster in Virtuoso 6. Note: sync; echo 3 > /proc/sys/vm/drop_caches first to not have it be a test of cache.
 * Banff Query #2
 * [[Media:Brainstage_Performance_Tests_05-20-08.xls]] = /Brainstage

=Queries whose performance must be sped up =
 * select distinct ?p where {?s ?p ?o}

Other stuff that is slow
Subject: CLEAR GRAPH benchmark From:  jar@mumble.net

Here's a data point for you: I deleted a 53 million triple graph (in the v1test store), and it took 90 minutes. That's a deletion rate of just under 600,000 triples per minute...