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

2013-12-14 Thread Egon Willighagen
On Sun, Dec 8, 2013 at 10:57 PM, Hugh Williams wrote: > No problem, looking back through the thread I presume the query you are > running is: > > SELECT DISTINCT ?property > WHERE { [] ?property [] } > ORDER BY ?property > > I believe ? Yeah, but I am starting to believe the crashes have nothing

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

2013-12-08 Thread Egon Willighagen
Hi Hugh, my apologies for the late reply... been busy again... On Wed, Oct 16, 2013 at 4:19 AM, Hugh Williams wrote: > What is the current triple count of your Virtuoso Server instance. 129857455 > Also when the database is "warm" can you please provide the output of running > the "status();"

Re: [Virtuoso-users] Virtuoso 7 LOD public endpoints

2013-11-23 Thread Egon Willighagen
On Fri, Nov 22, 2013 at 6:30 PM, Dimitris Kontokostas wrote: > I was wondering if you know any public LOD endpoint that uses virtuoso 7 > (open/professional edition) http://rdf.farmbio.uu.se/chembl/sparql Egon -- Dr E.L. Willighagen Postdoctoral Researcher Department of Bioinformatics - BiGCaT

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

2013-10-15 Thread Egon Willighagen
Dear Hugh, On Sat, Oct 12, 2013 at 3:36 PM, Hugh Williams wrote: > Glad to hear the stability has improved ... OK, it had crashed again in the past half day ... > With regards to SNORQL, what happens if you run the same query directly > against the Virtuoso SPARQL endpoint ie /sparql rather t

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

2013-10-12 Thread Egon Willighagen
Dear Kingsley, Hugh, On Fri, Oct 4, 2013 at 10:04 PM, Hugh Williams wrote: > Can you please add these params and restart the server. Done. I am sorry about this; I was pretty sure I copied in the new .ini file from the VOS7 distribution :( It sure seems to help with stability of the server. Tha

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

[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

[Virtuoso-users] SNORQL SPARQL query BOUND() problem

2010-02-08 Thread Egon Willighagen
ut would like to know if this is a bug in Virtuoso, or a bad SPARQL... Looking forward to hearing from you, Egon Willighagen 0.http://rdf.farmbio.uu.se/chembl/snorql/ 1.http://github.com/kurtjx/SNORQL -- Post-doc @ Uppsala University Proteochemometrics / Bioclipse Group of Prof. Jar

[Virtuoso-users] problem loading RDF...

2010-01-18 Thread Egon Willighagen
Hi all, I am trying to load a RDF document (made with a PHP script from a MySQL database) into Virtuoso with isql, but running into this exception: SQL> DB.DBA.RDF_LOAD_RDFXML_MT(file_to_string_output('/tmp/compounds.rdf', 'http://pele.farmbio.uu.se/chembl'); *** Error 37000: [Virtuoso Driver][V

[Virtuoso-users] how to delete triple store content with isql?

2009-11-02 Thread Egon Willighagen
using the isql utility? Looking forward to hearing from you! Egon Willighagen 0.http://pele.farmbio.uu.se/nmrshiftdb/sparql -- Post-doc @ Uppsala University Homepage: http://egonw.github.com/ Blog: http://chem-bla-ics.blogspot.com/ PubList: http://www.citeulike.org/user/egonw/tag/papers

[Virtuoso-users] Using Jena to query Virtuoso SPARQL end point with bif:contains

2009-10-15 Thread Egon Willighagen
Hi all, my apologies if this has already been discussed a million times before, but I have not been able to find an answer with Google... I am using Jena to do queries to remote SPARQL end points in the Jena plugin for Bioclipse [0], and the Virtuoso end points typically support the use of bif:co