Virtuoso performance

Prevent Limits of Sorted LIMIT/OFFSET query

SELECT ?p ?s
WHERE
  {
    {
      SELECT DISTINCT ?p ?s
      FROM <http://dbpedia.org>
      WHERE
        {
          ?s ?p <http://dbpedia.org/resource/Germany>
        } ORDER BY ASC(?p)
    }
  }
OFFSET 50000
LIMIT 1000

http://docs.openlinksw.com/virtuoso/rdfsparqlimplementationextent/

RAID 10 vs Virtuoso striping. What is the best for IO performance?

https://community.openlinksw.com/t/raid-10-vs-virtuoso-striping-what-is-the-best-for-io-performance/1407

Backward chaining

https://sourceforge.net/p/virtuoso/mailman/message/34144456/

Stripping

https://sourceforge.net/p/virtuoso/mailman/virtuoso-users/?viewmonth=201003

Efficient Use of SQL - SQL Execution profiling

profile ('SELECT COUNT (*) from ct_c a, ct_c b WHERE a.k2 = b.k1 option (loop, order)');

• http://docs.openlinksw.com/virtuoso/ptune/

Recommendations

CPU load goes up to 100% when Virtuoso runs its look up processing

• https://github.com/openlink/virtuoso-opensource/issues/714

Virtuoso.ini param

• http://docs.openlinksw.com/virtuoso/dbadm/

How to Update Large SPARQL Data avoiding due to database checkpoint abortion?

• http://docs.openlinksw.com/virtuoso/howtoloadlargedatanocheckpointabort/

Translate and Analyze modes for analyzing sparql queries

• http://docs.openlinksw.com/virtuoso/rdfperfcost/

The “MaxQueryCostEstimationTime"param should never be set in the INI file

• https://sourceforge.net/p/virtuoso/mailman/message/36149213/

Compiling and configuring Virtuoso

• https://github.com/dkmfbk/knowledgestore/wiki/Compiling-and-configuring-Virtuoso

Upgrading to the latest Virtuoso git develop/7 branch which is a 07.20.3219

• https://github.com/openlink/virtuoso-opensource/issues/655

Returns statistics for a running server as a result set

status('rhck');

• http://docs.openlinksw.com/virtuoso/fn_status/

Virtuoso 7 typically requires 10GB RAM per billion triples,

• https://sourceforge.net/p/virtuoso/mailman/message/34566700/

What is the storage cost per triple?

• http://docs.openlinksw.com/virtuoso/virtuosofaq1/

Virtuoso.ini settings parameters

• http://docs.openlinksw.com/virtuoso/dbadm/#ini_Database

Performance diagnostics

http://docs.openlinksw.com/virtuoso/perfdiag/

IO Bound

• https://en.wikipedia.org/wiki/I/O_bound

Configuring Virtuoso for Scale

• http://vos.openlinksw.com/owiki/wiki/VOS/VirtConfigScale

Performance Tuning Virtuoso for RDF Queries by using RDF indexes

• http://vos.openlinksw.com/owiki/wiki/VOS/VirtRDFPerformanceTuning