HI Sebastian,
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...
I know the feeling :)
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.
As far as i know the new layout is only recommended when using some of
the new features of version 6, particularly when using the facet browser.
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?
Not completely. The V6 layout from my previous mail has 1 primary index
plus 3 additional indexes.
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.
Sorry for the confusion.
I rechecked and when using LiteMode = 1 as in your configuration, these
indexes already are created on startup of the database. So you would not
have to create any of them for V5 (or V6 in future).
As discussed on Skype, we are more than happy to assist you in analyzing
some of your queries and advice you on what extra indexes may be needed
for your particular query patterns.
I will see if we can add some paragraph to the documentation explaining
the reason for the facet layout.
Patrick
