Thanks a lot for your help thus far. I am really grateful to you for the
same. But is there some other way out?
On Tue, Nov 26, 2013 at 7:55 PM, Hugh Williams wrote:
> Hi Rose,
>
> If you are repeat executing the same query multiple time then it will not
> be recompiled thus the time reported fo
Sorry to drop another mail. Actually I have a deadline tomorrow (I am done
with benchmarking other frameworks just Virtuoso is left) Is there some way
out by which I may find the query execution time excluding the compilation
time using version 6 of virtuoso?
On Tue, Nov 26, 2013 at 11:21 AM, Ros
Hi Rose,
If you are repeat executing the same query multiple time then it will not be
recompiled thus the time reported for subsequent runs of the same query is the
query execution time ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.
Ok. Is it possible to obtain the query execution time excluding the
compilation time using version 6 of virtuoso?
I think there is an execution time which virtuoso returns on normal query
execution. Can I obtain the query execution time by subtracting compilation
time from the execution time which
Hi Rose,
Actually the explain() function execution time is the compilation time for the
query as it does not actually run the query, just compile it ...
http://docs.openlinksw.com/virtuoso/fn_explain.html
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. //
I mean is the time returned by explain() the query execution time excluding
the compilation time?
On Tue, Nov 26, 2013 at 10:54 AM, Rose Beck wrote:
> Sorry my bad.
> explain() does return a time. Is the time which is returned by explain the
> query execution time?
>
> SQL> explain('sparql sel
Sorry my bad.
explain() does return a time. Is the time which is returned by explain the
query execution time?
SQL> explain('sparql select * where{?a ?b ?c}');
REPORT
VARCHAR
___
{
from DB.DBA.RDF_QUAD by RDF_QUAD_POGS
Hi Rose,
I don't see any single quotes around the query in the explain function call ?
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/
I tried to use explain() with SPARQL but its giving me the following error.
Also does explain return the query execution time(which does not include
the compilation time).
SQL> explain (sparql select * where{?a ?b ?c});
*** Error 37000: [Virtuoso Driver][Virtuoso Server]SQ074: Line 1: syntax
erro
Hi Rose,
You can use the explain() function to obtain a query plan with v6 but it will
not include the compilation time, see:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiagqueryplans
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.
Actually I do not have admin privileges on the server which I am using, so
wont be able to upgrade to version 7. Therefore it will be really great if
there is a method by which I may do profiling with virtuoso version 6.
On Mon, Nov 25, 2013 at 5:33 PM, Rose Beck wrote:
> Thanks a lot for h
Thanks a lot for helping again.
Is there some way out by which I may do profiling with V6?
On Mon, Nov 25, 2013 at 5:41 PM, Hugh Williams wrote:
> Hi Rose,
>
> As you are runing v6 the profile function will not work it requires v7+ ...
>
> The following shows simpler output with the compilation
Hi Rose,
As you are runing v6 the profile function will not work it requires v7+ ...
The following shows simpler output with the compilation time being stated at
the end:
SQL> profile ('sparql select count(*) where {?s ?p ?o}');
result
LONG VARCHAR
__
Dear Hugh,
Thanks a lot for the help.
I am using virtuoso version: Version 6.1.8-dev.3127-pthreads as of Aug 10
2013
Also I am unable to find the compilation and query execution time from the
example result set given below. Can you please help me a bit with this.
{
-- In the below excerpt some li
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/openlin
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
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 usin
After executing SPARQL queries in virtuoso using:
1. ./isql 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 retrie
18 matches
Mail list logo
