Re: [Bigdata-developers] Explain not working

[Rose B. <ros...@gm...>]

I need the total query evaluation time (i.e. till the last result is
obtained by the client).

On Thu, Nov 13, 2014 at 5:03 PM, Bryan Thompson <br...@sy...> wrote:
> Benchmarks normally report the total time for the client to obtain the
> result or the time until the friar result (for unusual cases such as open
> web query) rather than the time for the database to execute the query.
>
> If I recall you are attempting to find:
>
> - the query optimizer time
> - the query evaluation time (total, or u till first result?)
> - anything else?
>
> What is the purpose of this benchmark?
>
> Thanks,
> Bryan
>
> On Thursday, November 13, 2014, Rose Beck <ros...@gm...> wrote:
>>
>> Yes I understand. I need to run multiple queries and report their
>> total query execution time. I know I can do it with bigdata workbench
>> as it does give the total query execution time. But I am running 3000+
>> queries, so it is becoming impossible for me to note their query
>> execution time individually through bigdata workbench as it runs
>> within the browser. Is there some way: that using CURL I may do the
>> same on command line  --- an example will be really helpful.
>>
>> On Thu, Nov 13, 2014 at 4:49 PM, Bryan Thompson <br...@sy...> wrote:
>> > Rose,
>> >
>> > Those are URL query parameters.  They are appended onto the end of the
>> > SPARQL endpoint URL.
>> >
>> > http://.../sparql?explain
>> >
>> > If there are multiple URL query parameters then the next one is
>> > introduced
>> > with an ampersand &.  If there is a value associated with a parameter
>> > then
>> > it is ?foo=bar or &foo=bar.  This is standard http.
>> >
>> > The explain gives the time to run the query but not the time to send the
>> > results to the client.  The client (the workbench) is probably reporting
>> > the
>> > total time until the query results are fully materialized on the client.
>> >
>> > The explain output is explained on the performance optimization pages on
>> > the
>> > wiki.
>> >
>> > Thanks,
>> > Bryan
>> >
>> > On Thursday, November 13, 2014, Rose Beck <ros...@gm...> wrote:
>> >>
>> >> As stated at http://wiki.bigdata.com/wiki/index.php/NanoSparqlServer
>> >> one can pass "explain" as a parameter to SPARQL query passed in CURL.
>> >>
>> >> curl -X POST http://localhost:8080/bigdata/sparql --data-urlencode
>> >> 'query=SELECT * { ?s ?p ?o } LIMIT 1' -H 'Accept:application/rdf+xml'
>> >>
>> >> However, if I use the following (which works perfectly) well for
>> >> Virtuoso, I get an error:
>> >> curl -X POST http://localhost:8080/bigdata/sparql --data-urlencode
>> >> 'query=explain 'SELECT * { ?s ?p ?o } LIMIT 1'' -H
>> >> 'Accept:application/rdf+xml'
>> >>
>> >> Also "explain" on Bigdata workbench when executed in a browser gives
>> >> elapsed time of the time given below:
>> >> solutions=2, chunks=1, subqueries=0, elapsed=32ms.
>> >>
>> >> Is the elapsed time same as the query execution time -- if not then
>> >> what is the difference? Because on the browser bigdata reports
>> >> different elapsed time as well as query execution time.
>> >>
>> >>
>> >>
>> >> ------------------------------------------------------------------------------
>> >> Comprehensive Server Monitoring with Site24x7.
>> >> Monitor 10 servers for $9/Month.
>> >> Get alerted through email, SMS, voice calls or mobile push
>> >> notifications.
>> >> Take corrective actions from your mobile device.
>> >>
>> >>
>> >> http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
>> >> _______________________________________________
>> >> Bigdata-developers mailing list
>> >> Big...@li...
>> >> https://lists.sourceforge.net/lists/listinfo/bigdata-developers
>> >
>> >
>> >
>> > --
>> > ----
>> > Bryan Thompson
>> > Chief Scientist & Founder
>> > SYSTAP, LLC
>> > 4501 Tower Road
>> > Greensboro, NC 27410
>> > br...@sy...
>> > http://bigdata.com
>> > http://mapgraph.io
>> >
>> > CONFIDENTIALITY NOTICE:  This email and its contents and attachments are
>> > for
>> > the sole use of the intended recipient(s) and are confidential or
>> > proprietary to SYSTAP. Any unauthorized review, use, disclosure,
>> > dissemination or copying of this email or its contents or attachments is
>> > prohibited. If you have received this communication in error, please
>> > notify
>> > the sender by reply email and permanently delete all copies of the email
>> > and
>> > its contents and attachments.
>> >
>> >
>
>
>
> --
> ----
> Bryan Thompson
> Chief Scientist & Founder
> SYSTAP, LLC
> 4501 Tower Road
> Greensboro, NC 27410
> br...@sy...
> http://bigdata.com
> http://mapgraph.io
>
> CONFIDENTIALITY NOTICE:  This email and its contents and attachments are for
> the sole use of the intended recipient(s) and are confidential or
> proprietary to SYSTAP. Any unauthorized review, use, disclosure,
> dissemination or copying of this email or its contents or attachments is
> prohibited. If you have received this communication in error, please notify
> the sender by reply email and permanently delete all copies of the email and
> its contents and attachments.
>
>