Re: [Virtuoso-users] performance tuning

Hello Eric, 1. Indexes. Single bitmap index PGOS is sufficient as soon as all your queries specify graphs in use (via FROM clauses) and do not contain unbound predicates in triple patterns (even more, all predicates are constants in your samples). Other indexes are for cases of unbound P and/or

Re: [Virtuoso-users] performance tuning

Hugh, it is 64bits: virtuoso-t: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), stripped so, we will wait until 5.0.7 is out there... Erick Hugh Williams wrote: On 19 Jun 2008, at 16:00, Erick Antezana wrote: Hi Hugh,

Re: [Virtuoso-users] performance tuning

On 19 Jun 2008, at 16:00, Erick Antezana wrote: Hi Hugh, please see below: Hugh Williams wrote: Hi Erick, On 17 Jun 2008, at 09:11, Erick Antezana wrote: Hi Hugh, There was only one defined index on that table (RDF_QUAD_OGPS). I have added the following: create indexRDF_QUAD_

Re: [Virtuoso-users] performance tuning

Hi Hugh, please see below: Hugh Williams wrote: Hi Erick, On 17 Jun 2008, at 09:11, Erick Antezana wrote: Hi Hugh, There was only one defined index on that table (RDF_QUAD_OGPS). I have added the following: create indexRDF_QUAD_GSPO on DB.DBA.RDF_QUAD (G,S,P,O); create bitmap index

Re: [Virtuoso-users] performance tuning

Hi Erick, On 17 Jun 2008, at 09:11, Erick Antezana wrote: Hi Hugh, There was only one defined index on that table (RDF_QUAD_OGPS). I have added the following: create indexRDF_QUAD_GSPO on DB.DBA.RDF_QUAD (G,S,P,O); create bitmap index RDF_QUAD_POGS on DB.DBA.RDF_QUAD (P,O,G,S); create

Re: [Virtuoso-users] performance tuning

Hi Hugh, There was only one defined index on that table (RDF_QUAD_OGPS). I have added the following: create indexRDF_QUAD_GSPO on DB.DBA.RDF_QUAD (G,S,P,O); create bitmap index RDF_QUAD_POGS on DB.DBA.RDF_QUAD (P,O,G,S); create bitmap index RDF_QUAD_PSOG on DB.DBA.RDF_QUAD (P,S,O,G); c

Re: [Virtuoso-users] performance tuning

Hi Erick, Can you confirm that the bitmap indexes are in place on your Virtuoso RDF Quad store table "DB.DBA.RDF_QUAD", you can check this from the Virtuoso Conductor by checking the indexes this table ? The indexes we recommend be set on the table are: create bitmap index rdf_quad_opgs on

Re: [Virtuoso-users] performance tuning

Hi Hugh, Indeed, now it works. Here you are the first report: Query result: REPORT VARCHAR { Precode: 0: $25 "OBO#GO_0005737" := Call DB.DBA.RDF_MAKE_IID_OF_QNAME_SAFE ((http://www.semantic-systems-biology.org/ontology/rdf/OBO#GO_0005737)>) 7: $26 "ema#label" := Call DB.DBA.RDF_MAKE_IID_OF_Q

Re: [Virtuoso-users] performance tuning

Hi Erick, Sorry, I forgot to have you prefix the queries with the keyword 'sparql' to tell Virtuoso to execute via the SPARQL rather than SQL engine, so the query below would be: explain('sparql prefix rdf: select distinct ?ontology from

Re: [Virtuoso-users] performance tuning

Hugh, I tried with the isql command line ensuring that the query is all on the same line: SQL> explain('prefix rdf: select distinct ?ontology from where{ ?term rdf:type ?ontology. } order

Re: [Virtuoso-users] performance tuning

Hi Erick, If you are executing from the isql commandl line then you most probably need to ensure the query is all on the same line as multiple lines will not be passed as one query to the server. Multiple lines would best in the Conductor Interactive SQL UI, which you could try also. B

Re: [Virtuoso-users] performance tuning

Hi Hugh, I tried to run both queries (first surrounded by the 'explain' command) and I've got the following error message: The statement execution did not return a result set. SQLState: 37000 Message: SQ074: Line 1: syntax error at 'rdf' before ':' I also tried without the 'explain' comm

Re: [Virtuoso-users] performance tuning

Hi Eric, We have been able to see the hangs you report with the sample queries below. Can you please provide the output of running the Virtuoso explain command against these 2 queries and provide this output. The explain command provides more details on the query execution plan with Vir

Re: [Virtuoso-users] performance tuning

Hugh, I the first example I sent, you have to change: has_evidence_code by has_evidence Thanks, Erick Hugh Williams wrote: Hi Erick, You have not provided some sample queries for which these performance issues are being encountered as requested in point 3 ? Best Regards Hugh Williams Op

Re: [Virtuoso-users] performance tuning

Hi Erick, You have not provided some sample queries for which these performance issues are being encountered as requested in point 3 ? Best Regards Hugh Williams OpenLink Software On 6 Jun 2008, at 14:09, Erick Antezana wrote: Hi Hugh, here you are the 'top' output: top - 14:57:25 up 13

Re: [Virtuoso-users] performance tuning

Hi Erick, Can you please provide the following: 1. The output of running the top command on the machine at the time you are running these problem queries such that we can see the CPU, I/ O etc consumption 2. How many hard disks and CPUs are in the machine currently 3. Some of these problem

[Virtuoso-users] performance tuning

Hello, could anybody point out some doc/examples for doing some performance tuning? I have been playing (in a linux box with 16GB RAM, 1 CPU, ...) with some params (numberofbuffers, maxcheckpointremap, O_DIRECT, etc) as indicated in: http://virtuoso.openlinksw.com/wiki/main/Main/VOSScale htt