Re: I need advice about how to implement a "dynamic dispatch" of properties through inference support

2016-08-08 Thread Dave Reynolds
On 08/08/16 17:19, Simon Schäfer wrote: On Mon, 08 Aug 2016 10:28:55 +0200 Dave Reynolds wrote > > This doesn't matter for your later questions but this example looks like > it is confusing classes and properties. > > s: seems to be a property so the

SPARQL query optimization question

2016-08-08 Thread Mark D Wood
I am trying to piece together three different but connected portions of a graph extracted from a large triple store, and I am surprised by some performance results that I see. Some guidance would be appreciated. The most obvious way to construct the desired data is the following, where I'm

Re: I need advice about how to implement a "dynamic dispatch" of properties through inference support

2016-08-08 Thread Simon Schäfer
On Mon, 08 Aug 2016 04:20:51 +0200 Adrian Walker wrote > Simon, > > May I ask please, what is the end-user application that is to be supported > with the techniques you describe? It is difficult to describe for me because it is a research project.

Re: I need advice about how to implement a "dynamic dispatch" of properties through inference support

2016-08-08 Thread Simon Schäfer
On Mon, 08 Aug 2016 10:28:55 +0200 Dave Reynolds wrote > > This doesn't matter for your later questions but this example looks like > it is confusing classes and properties. > > s: seems to be a property so the relationship between sc: and sd:

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
Any way thank you for help Håvard! I might have to rethink the system so that we can use partial queries. It's at least a sure way to make things quicker. -Mikael On 8.8.2016 15:33, Håvard Ottestad wrote: Hi Mikael I don't think I can be of much more help now. Maybe if you post the data

Re: Slow SPARQL query

2016-08-08 Thread Håvard Ottestad
Hi Mikael I don't think I can be of much more help now. Maybe if you post the data somewhere then I could try the queries myself to see if I could make it faster. Håvard > On 08 Aug 2016, at 14:16, Mikael Pesonen wrote: > > > For some reason with filter I dont

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
For some reason with filter I dont get any results (corrected == to = ). Without filter it takes 12 secs so about the same speed. -Mikael On 8.8.2016 14:40, Håvard Ottestad wrote: Maybe your inner select gets executed for every results of the second graph query. How about executing them

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
It takes 8 seconds, so about half of the time. It returns ~16k results. I'm guessing getting this faster is very hard on software level? Entire graph contains ~400k triplets. -Mikael On 8.8.2016 14:30, Håvard Ottestad wrote: How long does this part take? And how many results are you

Stall when committing a write transaction.

2016-08-08 Thread Dick Murray
Hello. Looking for ideas and if anyone else has come across this... I have a bulk load (same as the previous OOME question) which auto commits after 25k quads have been added then begins a new write transaction. All of the commits average 2 seconds but one takes 42 seconds. ~500K quads are added

Re: Slow SPARQL query

2016-08-08 Thread Håvard Ottestad
How long does this part take? And how many results are you getting? SELECT DISTINCT ?s ?p ?o WHERE { GRAPH { ?s . ?s ?child .

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
Also tested original query but removed all * from narrower, so ontology query returns less keywords, and query time dropped to half. Still too slow... -Mikael On 8.8.2016 13:43, Andy Seaborne wrote: There is a a certain amount of "it depend" here: what's the data stored in? what shape is

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
Hi Andy, storage is started like this: /usr/bin/java -Xmx3600M -jar /home/text/tools/apache-jena-fuseki-2.3.1/fuseki-server.jar --update --port 3030 --loc=../apache-jena-3.0.1/DB /ds Ontology data is simple SKOS, and document data is also simple DC metadata triplets. Query returns ~15k

Re: Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
Thank you for the answer! That order seemed to be a bit slower. Br, Mikael On 8.8.2016 13:37, Håvard Ottestad wrote: Is this any better? SELECT DISTINCT ?s ?p ?o WHERE { GRAPH { ?s

Re: Slow SPARQL query

2016-08-08 Thread Andy Seaborne
There is a a certain amount of "it depend" here: what's the data stored in? what shape is the data?( which Jena version?) In the next release, and available in development builds is: https://issues.apache.org/jira/browse/JENA-1195 where property* got speeded up recently. Usually, it took

Slow SPARQL query

2016-08-08 Thread Mikael Pesonen
Hi, I'm not if this is the correct forum to ask but hope you can help. This query takes over 20 seconds with jena: SELECT DISTINCT ?s ?p ?o WHERE { GRAPH { SELECT DISTINCT ?child WHERE { { skos:narrower* ?child} UNION

Re: I need advice about how to implement a "dynamic dispatch" of properties through inference support

2016-08-08 Thread Dave Reynolds
Hi, On 08/08/16 00:23, Simon Schäfer wrote: Hello there, I'm currently designing a system on top of Jena (or on top of semantic web technologies in general) and I arrived at the point where I need to get inference support for SPARQL queries up and running. I looked at