Hi Stefano, The 5 default indexes (2 full & 3 partial) should suffice for most query work loads and there should be no need to create additional or delete existing indexes.
Are you experiencing specific query performance issues, if so please detail them ? What is the size ie # of triples of the database ? How much memory is available and how much has been configured for Virtuoso use ? Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ <http://www.openlinksw.com/> Weblog -- http://www.openlinksw.com/blogs/ <http://www.openlinksw.com/blogs/> LinkedIn -- http://www.linkedin.com/company/openlink-software/ <http://www.linkedin.com/company/openlink-software/> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> Google+ -- http://plus.google.com/100570109519069333827/ <http://plus.google.com/100570109519069333827/> Facebook -- http://www.facebook.com/OpenLinkSoftware <http://www.facebook.com/OpenLinkSoftware> Universal Data Access, Integration, and Management Technology Providers > On 9 Mar 2016, at 23:58, Stefano Ortona <sedan...@hotmail.it > <mailto:sedan...@hotmail.it>> wrote: > > Hi there, > > I have a simple question. > I have a huge RDF triples database loaded into Virtuoso and the Scenario is > the following: > > - Data is loaded only once (there are not insert after the first loading); > - The only queries used are on subject and object, specifying the graph; > something like: > "select * from <graph> where {<entity> ?rel ?obj.}” and "select * from > <graph> where {?sub ?rel <entity>.}". > > I’ve looked into this > (http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html > <http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html>) and > apparently default indexes favour queries on predicates, in my case I want > indexes to fast retrieve queries where only graph and subject or graph and > object are specified. > Do you know if I should create other indexes? And if I should delete existing > ones? > > Thanks, > Stefano > ------------------------------------------------------------------------------ > Transform Data into Opportunity. > Accelerate data analysis in your applications with > Intel Data Analytics Acceleration Library. > Click to learn more. > http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140_______________________________________________ > > <http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140_______________________________________________> > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users