Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-24 17:59, Hugh Williams wrote: > Hi Bart, > > Hmmm, note sure why you would need to run as root to get the profile > plan, especially if it was not required for explain ? Could it have to do with file/directory permissions? The directory from which I start virtuoso has the following p

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, Hmmm, note sure why you would need to run as root to get the profile plan, especially if it was not required for explain ? Anyway, the query profiles will be analysed by development would will be able to advise on how the speed might be improved or why they are slow, so will let you k

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-24 16:45, Bart Vandewoestyne wrote: > > I'm still struggling to get this profiling going... After starting up > my Virtuoso, i immediately try profiling from within ISQL but I get no > output: > > bart@hp-g7-02:~$ isql > OpenLink Interactive SQL (Virtuoso), version 0.9849b. > Type HELP;

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-24 15:16, Hugh Williams wrote: > Hi Bart, > > Is seems the "set profile on" option is not implemented in the VOS isql > program, so will have to make a request to have that option added as > it is in the commercial version. But you still can just run the profile > command with the quer

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, Is seems the "set profile on" option is not implemented in the VOS isql program, so will have to make a request to have that option added as it is in the commercial version. But you still can just run the profile command with the query in single quotes directly from isql ie SQL> prof

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-23 14:55, Hugh Williams wrote: > Hi Bart, > > You still have not provided the "profile" for each query. You can do > this by running "SET PROFILE ON/OFF" as did for the explain plans ... Hugh, I'm confused here. I am following the instructions on http://virtuoso.openlinksw.com/datas

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, You still have not provided the "profile" for each query. You can do this by running "SET PROFILE ON/OFF" as did for the explain plans ... Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.ope

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-18 19:19, Hugh Williams wrote: > Hi Bart, > > The explain command whilst useful only provide the compile into,, where > the new v7 "profile(0" function provided both compile and execute info. > and it was I requested ie > > profile('select * from table where field = ''text'''); > > The p

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, The explain command whilst useful only provide the compile into,, where the new v7 "profile(0" function provided both compile and execute info. and it was I requested ie profile('select * from table where field = ''text'''); The plans will be analysed by development ... Best

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-18 12:53, Hugh Williams wrote: > Hi Bart, > > If you cannot provide the data then the next best thing would be to get > the "profile" for the problem queries ie the compiler and execution > plans for analysis as detailed at: > > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-18 04:50, Hugh Williams wrote: > > [Hugh] I note that you do not appear to have any of the parameters the new v7 > vectored execution set in your INI file , these being: > > MaxQueryMem= 2G ; memory allocated to query processor > VectorSize = 1000

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, If you cannot provide the data then the next best thing would be to get the "profile" for the problem queries ie the compiler and execution plans for analysis as detailed at: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-18 04:50, Hugh Williams wrote: > >> What else could I try? Do you need any further info from my side? > > [Hugh] I note that you do not appear to have any of the parameters the new v7 > vectored execution set in your INI file , these being: > > MaxQueryMem= 2G ; m

Re: [Virtuoso-users] speeding up SPARQL query

Bart, On 17 Apr 2014, at 15:42, Bart Vandewoestyne wrote: > On 2014-04-17 15:04, Hugh Williams wrote: >> Hi Bart, >> >> I note your Virtuoso version is reported as "Version >> 07.00.3203-pthreads for Linux as of Mar 26 2014" which despite having >> been be built in March 2014, a 3203 build is

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-17 15:04, Hugh Williams wrote: > Hi Bart, > > I note your Virtuoso version is reported as "Version > 07.00.3203-pthreads for Linux as of Mar 26 2014" which despite having > been be built in March 2014, a 3203 build is about the original 7.0 > release code from a year ago. The latest bui

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-17 15:04, Hugh Williams wrote: > Hi Bart, > > I note your Virtuoso version is reported as "Version > 07.00.3203-pthreads for Linux as of Mar 26 2014" which despite having > been be built in March 2014, a 3203 build is about the original 7.0 > release code from a year ago. The latest bui

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, I note your Virtuoso version is reported as "Version 07.00.3203-pthreads for Linux as of Mar 26 2014" which despite having been be built in March 2014, a 3203 build is about the original 7.0 release code from a year ago. The latest builds are 07.10.3207+ available from git, thus I sug

Re: [Virtuoso-users] speeding up SPARQL query

On 2014-04-16 11:43, Hugh Williams wrote: > Hi Bart, > > Your status(''); output shows that the default Buffers size of 2 is > being allocated on server startup and all quickly used due to the size > of your dataset, with the "NumberOfBuffers" setting of 200 in the > INI file not being pick

Re: [Virtuoso-users] speeding up SPARQL query

Hi Bart, Your status(''); output shows that the default Buffers size of 2 is being allocated on server startup and all quickly used due to the size of your dataset, with the "NumberOfBuffers" setting of 200 in the INI file not being pickup due to those leading spaces which should be rem

[Virtuoso-users] speeding up SPARQL query

Hello list, I have the following query: SELECT ?val (COUNT(DISTINCT ?id) as ?vc) WHERE { ?id ?val ; ?property1 ?property_value1 ; ?property2 ?property_value2 . ?property_value1 bif:contains "'foo'" . ?property_value2 bif: