Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-04 Thread Dimitris Kontokostas
Hi Hugh, I can confirm this error on live.dbpedia.org (Version: 07.00.320) although conductor doesn't complain maybe jdbc is more strict and throws an exception if it makes sense, you could add a few triples before and after the date to simulate dbpedia live better the number is usually between 1

Re: [Virtuoso-users] Possible datetime bug in VirtJDBC4

2013-10-04 Thread Hugh Williams
Hi Dimitar, We have tried nserts and querys of similar data to what you provided VOS7.00.3203 via conductor and can still get past -100: sparql clear graph ; sparql insert into graph { "-0031-09-02"^^ }; sparql insert into graph { "-4800-04-06"^^

Re: [Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Kingsley Idehen
On 10/4/13 4:59 AM, Egon Willighagen wrote: ;; Note the default settings will take very little memory ;; but will not result in very good performance ;; NumberOfBuffers = 1 MaxDirtyBuffers = 6000 At first blush, you seem to be using a Virtuoso 6 INI file without any of the

Re: [Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Hugh Williams
Hi Egon, On reviewing the virtuoso.ini file in use on your server it seems to be missing the following new Virtuoso params in the the "[Parameters]" section: MaxQueryMem= 2G ; memory allocated to query processor VectorSize = 1000 ; initial parallel query vec

[Virtuoso-users] phantom graph V7.0.0.

2013-10-04 Thread Erich Bremer
Hi, I'm been loading and reloading graphs in V7.0.0 and on one particular load, the graph would not load. It turned out that I had an error in the turtle file I was loading, but, it seems one triple from the file loaded. I can see this triple if I sparql for it, but, the graph that I wa

Re: [Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Egon Willighagen
Hugh, On Fri, Oct 4, 2013 at 2:38 PM, Hugh Williams wrote: > 1. The output of running the "status();" run from command from the Virtuoso > "isql" commandline tool REPORT VARCHAR ___

Re: [Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Egon Willighagen
On Fri, Oct 4, 2013 at 11:18 AM, Jerven Bolleman wrote: > This query is very cheap to answer no matter which store is used. Good point. Because it takes some 2secs on average I did not think of it as being a cheap call: http://labs.mondeca.com/sparqlEndpointsStatus/details/farmbio-chembl.html E

Re: [Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Hugh Williams
Hi Egon, Can you please provide the following for review: 1. The output of running the "status();" run from command from the Virtuoso "isql" commandline tool 2. The triple count of the database with "select count(*) where {?s ?p ?o};" If you load the data in the Quad Store from an empty datab

Re: [Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Jerven Bolleman
Hi Egon, Not a virtuoso expert. But about the mondica, I would not expect a different result between VOS6 and VOS7. The query mondica uses for measuring uptime is ASK { ?s ?p ?o .} This query is very cheap to answer no matter which store is used. So in the mondica is measuring the time need

[Virtuoso-users] how to 'debug' VOS7 performance?

2013-10-04 Thread Egon Willighagen
Hi VOS community, we have recently upgraded our VOS7 SPARQL end point for the ChEMBL-RDF data [0]: http://rdf.farmbio.uu.se/chembl/sparql It's crashed a few times (not sure why; I'm now monitoring it day by day), but I was originally looking forward to the faster performance. I started from a fre