Re: [Virtuoso-users] performance toll for using variables as properties

2016-08-08 Thread Olivier Dameron
Dear Ivan, Thank you for the very detailed answer! We will investigate whether solution #3 would work for us. 500x performance improvement sure would be nice:-) Kind regards Olivier Dameron On 07/25/2016 06:58 AM, Ivan Mikhailov wrote: > Hello Oliver, > > The cost of "variable P" heavily depe

Re: [Virtuoso-users] performance toll for using variables as properties

2016-07-24 Thread Ivan Mikhailov
Hello Oliver, The cost of "variable P" heavily depends on the sample query. 1. In good case the overhead is zero. It's possible when graphs (G) are known or almost all data of the dataset are in very numerous small graphs, so it's cheaper to read whole graphs than to try to use additional indices

[Virtuoso-users] performance toll for using variables as properties

2016-07-22 Thread Olivier Dameron
Dear Virtuosans, I noticed that queries can be much slower when using variables as properties (even if the variable can only have one value) e.g.: DATA (extract): :display :startRelation :posStart. :gene0 rdf:type :Gene. :gene0 :posStart "53416"^^xsd:numeric. :gene1 rdf:type :Gene. :gene1 :posS