Hi Rose,
What Virtuoso version are you using as this is a Virtuoso 7+ feature ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 25 Nov 2013, at 11:12, Rose Beck <rosebeck...@gmail.com> wrote:
> Dear Hugh,
>
> Thanks a lot for the help. I tried to profile using profile but I am getting
> the following errors:
> SQL> profile('sparql select ?a?b?c where{?a ?b ?c}');
>
> *** Error 42001: [Virtuoso Driver][Virtuoso Server]SR185: Undefined procedure
> DB.DBA.profile.
> at line 9 of Top-Level:
> profile('sparql select ?a?b?c where{?a ?b ?c}')
> SQL> sparql profile('select ?a?b?c where{?a ?b ?c}');
>
> *** Error 37000: [Virtuoso Driver][Virtuoso Server]SQ074: Line 1: SP030:
> SPARQL compiler, line 1: syntax error at 'profile' before '('
> at line 10 of Top-Level:
> sparql profile('select ?a?b?c where{?a ?b ?c}')
>
>
>
> On Mon, Nov 25, 2013 at 4:35 PM, Hugh Williams <hwilli...@openlinksw.com>
> wrote:
> Hi Rose,
>
> With Virtuoso 7 you can obtain the compilation (query plan) and query
> execution time of a query using the "profile" function as detailed at:
>
>
> http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#readingqueryprofile
>
> You can also enable general query logging and profiling using the
> "prof_enable" function as detailed at:
>
> http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#querylogging
>
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 25 Nov 2013, at 09:15, Rose Beck <rosebeck...@gmail.com> wrote:
>
>> After executing SPARQL queries in virtuoso using:
>> 1. ./isql 1111 dba dba
>> 2. And then firing the SPARQL query
>>
>> After this virtuoso returns the query execution time. So does the returned
>> time include the plan generation time. If yes, is it possible to find:
>> (plan generation time) and (time to retrieve the results after the plan has
>> already been generated by Virtuoso)?
>>
>> I need to know these query times as I am benchmarking Virtuoso against
>> postgreSQL. With postgresql I am able to separately retrieve the query
>> execution time after the plan has been generated by postgresql using
>> \timing. It would be great if Virtuoso could also give me the time it takes
>> to retrieve the results after the plan has been generated separately as
>> that would help me take a one to one comparison.
>>
>> I'll be really grateful to you for the guidance.
>> ------------------------------------------------------------------------------
>> Shape the Mobile Experience: Free Subscription
>> Software experts and developers: Be at the forefront of tech innovation.
>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>> conversations that shape the rapidly evolving mobile landscape. Sign up now.
>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
