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 Quentin,
Are you able to provide a test case for internal recreation of this issue ?
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
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.
Incorrect results appear to be generated when running this against:
http://dbpedia.org/sparql
As written, two rows are returned which are correct. When the NOT EXISTS
filter is uncommented, no results are returned despite that triple clearly
not existing.
==
pr
By dataset, I mean a url that represents a graph name.
As in: http://example.org/dataset/TestData/
On 26 November 2013 13:07, Quentin wrote:
> The offending code, that reliably reproduces the crash in my environment,
> is:
> split_and_decode(in_datasets,0,'%3B');
>
> Where in_datasets is a urle
The offending code, that reliably reproduces the crash in my environment,
is:
split_and_decode(in_datasets,0,'%3B');
Where in_datasets is a urlencoded. semicolon separated list of datasets.
$ virtuoso-t -?
Virtuoso Open Source Edition (Column Store) (multi threaded)
Version 7.0.1-dev.3203-pthread
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
Both are available :-) Juste I forgot the last "/" at the end :
http://data.lirmm.fr/sparql/
My bad sorry :-(
Best.
Julien.
2013/11/25 Hugh Williams
> Hi Julien,
>
> It seems to be accessible on the Virtuoso default port 8890, rather than
> 80:
>
> http://data.lirmm.fr:8890/sparql/
>
> Bes
Hi Julien,
It seems to be accessible on the Virtuoso default port 8890, rather than 80:
http://data.lirmm.fr:8890/sparql/
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
Hi,
There is http://data.lirmm.fr/sparql too :-)
Best.
Julien.
2013/11/25 Dimitris Kontokostas
> Thank you Kingsley & Egon,
>
> I used your endpoints as sample configurations for my online sparql
> debugging app
> http://databugger.aksw.org/
>
> Best,
> Dimitris
>
>
> On Sat, Nov 23, 2013 at
Thank you Kingsley & Egon,
I used your endpoints as sample configurations for my online sparql
debugging app
http://databugger.aksw.org/
Best,
Dimitris
On Sat, Nov 23, 2013 at 5:38 PM, Egon Willighagen <
egon.willigha...@gmail.com> wrote:
> On Fri, Nov 22, 2013 at 6:30 PM, Dimitris Kontokostas
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
Dear
all,
We
are pleased to announce the next version of Databugger, a
test-driven data debugging framework for the Web of Data. This
version brings various improvements in an addition to a web
interface.
You
can
24 matches
Mail list logo
