Re: [Virtuoso-users] Getting type information from SPARQL queries through JDBC interface

2008-06-19 Thread Hugh Williams
Hi Jan, In a way I was wonder if/when you might/would ask this question, as we hit the same issue whilst working on our Sesame/Jena/Redland RDF Providers and added support to the JDBC and ODBC Driver to provide this differentiation. This required updates to both the Virtuoso Server and JD

[Virtuoso-users] Getting type information from SPARQL queries through JDBC interface

2008-06-19 Thread Jan Stette
Hi, I'm executing SPARQL queries through the OpenLink Virtuoso JDBC driver. My question is: when I look at the Java ResultSet returned after executing my query, how can I get information about what type of node that each variable is bound to? For example, if doing a simple query like: sparq

Re: [Virtuoso-users] performance tuning

2008-06-19 Thread Erick Antezana
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

2008-06-19 Thread Hugh Williams
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

2008-06-19 Thread Erick Antezana
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

2008-06-19 Thread Hugh Williams
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