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
