Re: [Virtuoso-users] Can't tell is Virtuoso install is broken or there are other problems

2011-03-29 Thread Hugh Williams
Hi Alex, I presume you are using the Virtuoso distribution shipped wit ubuntu in which case the Virtuoso normal “isql" program is called “isql-vt” in these distributions so as to not conflict with the “isql” program that was already being shipped with Ubtuntu before Virtuoso, see: http

Re: [Virtuoso-users] Can't tell is Virtuoso install is broken or there are other problems

2011-03-29 Thread Kingsley Idehen
On 3/29/11 2:08 PM, Alex Genadinik wrote: Hello, I was trying to see if I can connect to Virtuoso on Ubuntu using the command: |isql dba dba | But I got this error: |[ISQL]ERROR: Could not SQLConnect | When I did this: |isql-v | I got this error: |[IM010][unixODBC][Driver Man

[Virtuoso-users] Intention of various places where Virtuoso is installed

2011-03-29 Thread Alex Genadinik
Hello, I am new to Virtuoso and I am trying to get it working on Ubuntu. I have a few questions about the different spots Virtuoso gets installed and what the intention of each spot is: /var/lib/virtuoso-opensource - that is where I actually install the databases I want to use, correct? /usr/loc

[Virtuoso-users] Can't tell is Virtuoso install is broken or there are other problems

2011-03-29 Thread Alex Genadinik
Hello, I was trying to see if I can connect to Virtuoso on Ubuntu using the command: isql dba dba But I got this error: [ISQL]ERROR: Could not SQLConnect When I did this: isql -v I got this error: [IM010][unixODBC][Driver Manager]Data source name too long [ISQL]ERROR: Could not SQLConn

Re: [Virtuoso-users] Strange result while querying an OWL ressource

2011-03-29 Thread Mitko Iliev
Hi Benoit, The source file contains duplicates, can see that if you export file with rapper to ntriples and take unique count : rapper -i rdfxml -o ntriples lycocyc_2.0.biopax.owl > lycocyc_2.0.biopax.nt then do : sort -u lycocyc_2.0.biopax.nt | wc -l as for your queries, you must check your s

Re: [Virtuoso-users] Prepared statement performance with SPARQL

2011-03-29 Thread Timo Westkämper
Hi Ivan. Thanks for the explanation. My queries are quite simple and I have huge performance differences. It looks index activation is very much dependent if an value binding is given inline or via prepared statement binding. For example if I use the query SELECT * WHERE { ?o } and SELE

Re: [Virtuoso-users] Strange result while querying an OWL ressource

2011-03-29 Thread Carreres Benoit
Hello hugh, thank you for your help, I uploaded the owl file to virtuoso via the web interface (It is not installed on my computer) If I make the same query as you (select count), I have the same number of triples -> 214714 If I do the counting of triples via raptor, it returns me 214717. Three

Re: [Virtuoso-users] Prepared statement performance with SPARQL

2011-03-29 Thread Timo Westkämper
Hi Hugh. Hi Timo, Is the performance difference the same following repeat execution of the prepared statement with URI binding ? Yes. it would still worth seeing some pseudo code showing how the prepared statement is being set and the parameters passed to it ? The PreparedStatement is creat

Re: [Virtuoso-users] Prepared statement performance with SPARQL

2011-03-29 Thread Ivan Mikhailov
Hello Timo, When parameter values are placed right into the text of the query, the compiler has a chance to gather statistics about amounts of the specific combinations of P and O in indexes and chose the best plan specially for these statistics. With `iri(??)` it can only make some "average" plan

Re: [Virtuoso-users] Strange result while querying an OWL ressource

2011-03-29 Thread Hugh Williams
Hi Carreres, How exactly are you attempting to load the owl file as it loads fine using the Virtuoso RDF_XML function: $ /opt/virtuoso/bin/isql Connected to OpenLink Virtuoso Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for