On Tuesday 27 October 2009 21:42:15 Patrick van Kleef wrote: > I suggest you read the following document: > > http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html
I did, don't ask me why I still messed up the indexes. I don't get enough sleep these days... Anyway, something is still unclear to me: In which situation do I actually need to create a new RDF_QUAD table? The documentation states that this needs to be done whenever I already have quadruples that I want to preserve. You, however, seem to say that I only need to do that for V6. Also it looks to me that for V6 you propose to use indexes OPGS,POGS, and GPOS only, while for V5 you propose to add them in addition to the default ones? This confuses me also since the defaults in 5.0.12 are GPOS,OGPS,OPGS,POGS which already include the 3 "new" ones and the one from the documentation which is proposed for situations in which the graph is not always given. So it looks as if the defaults already match the proposed ones. Cheers, Sebastian > For virtuoso 5.0.12 you should probably create the following extra indexes: > > create bitmap index RDF_QUAD_OPGS on DB.DBA.RDF_QUAD (O, P, G, S); > > create bitmap index RDF_QUAD_POGS on DB.DBA.RDF_QUAD (P, O, G, S); > > create bitmap index RDF_QUAD_GPOS on DB.DBA.RDF_QUAD (G, P, O, S); > > Note that the documentation also mentions the partition option but this > is not used with V5. > > > For V6 i suggest you change to the facet browser layout, which is a bit > more complicated: > > > log_enable (2); > > drop index RDF_QUAD_OGPS; > > checkpoint; > > create table R2 (G iri_id_8, S iri_id_8, P iri_id_8, O any, > primary key (S, P, O, G)); > > alter index R2 on R2 partition (S int (0hexffff00)); > > insert into r2 (g, s, p, o) SELECT g, s, p, o from rdf_quad; > > drop table RDF_QUAD; > > checkpoint; > > alter table r2 rename RDF_QUAD; > > create bitmap index RDF_QUAD_OPGS on DB.DBA.RDF_QUAD (O, P, G, S) > partition (O varchar (-1, 0hexffff)); > > create bitmap index RDF_QUAD_POGS on RDF_QUAD (P, O, G, S) > partition (O varchar (-1, 0hexffff)); > > create bitmap index RDF_QUAD_GPOS on RDF_QUAD (G, P, O, S) > partition (O varchar (-1, 0hexffff)); > > checkpoint; > > log_enable (1); > > > > > Patrick >
