Hi
Note sure what clearing the kernel cache has to do with this behaviour, but I
do not see negative differences taking a sample query like counting triples:
SQL> explain('sparql select count(*) where {?s ?p ?o}');
REPORT
VARCHAR
_______________________________________________________________________________
{
{ fork
RDF_QUAD_POGS 1.4e+07 rows()
After code:
0: sum callret-0 1 set no set_ctr
5: BReturn 0
}
Select (callret-0)
}
11 Rows. -- 2 msec.
SQL> sparql select count(*) where {?s ?p ?o};
callret-0
INTEGER
_______________________________________________________________________________
18885386
1 Rows. -- 4946 msec.
SQL>
So, 2ms to compile , 4946ms to compile and execute ...
As said before if you want better query profiling then you need to use v7 ...
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 19 Dec 2013, at 15:19, Jyoti <jyoti...@gmail.com> wrote:
> Hi,
>
> I read it in one of the discussions on virtuoso's mailing list that cold
> query times can be obtained for Virtuoso 6 by subtracting explain()
> compilation time from the cold run time.
>
> However when I did so after clearing cache using echo 3 >/proc/sys/vm/drop
> caches and restarting virtuoso. I find for a lot of queries the time obtained
> after subtracting explain() compilation time from the cold run time - comes
> out to be negative.
>
> I want to perform profiling with virtuoso 6, is there some way out?
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
