Not logged in : Login

About: Comment 2 by Hugh Williams (hwilliams)     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : sioc:Post, within Data Space : ods-qa.openlinksw.com:8896 associated with source document(s)

AttributesValues
type
Date Created
  • 2020-03-01T22:55:51.671Z
Date Modified
  • 2020-03-01T22:55:51.671Z
label
  • Comment 2 by Hugh Williams (hwilliams)
seeAlso
discourse:topic_slug
  • sparql-query-execution-time-breakdown-into-essential-steps
discourse:post_number
  • 2
discourse:quote_count
  • 0
discourse:incoming_link_count
  • 14
discourse:score
  • 86.8
discourse:topic_id
  • 1561
described by
has container
content
  • proxy:entity/https/community.openlinksw.com/t/sparql-query-execution-time-breakdown-into-essential-steps/1561#content_5519

    The Virtuoso isql command output is showing the query execution time in the Virtuoso engine, whereas you timing from the command line would also include the OS time for processing the query and displaying the result.

    You can also use the OS time function to time the queries running time in the terminal session which breaks the time down into real, user & system times:

    De-iMac-2692:~ hwilliams$ time isql 1111 dba dba exec="sparql select * where {?s ?p ?o} limit 1;"
    Connected to OpenLink Virtuoso
    Driver: 07.20.3214 OpenLink Virtuoso ODBC Driver
    OpenLink Interactive SQL (Virtuoso), version 0.9849b.
    Type HELP; for help and EXIT; to exit.
    s                                                                                 p                                                                                 o
    LONG VARCHAR                                                                      LONG VARCHAR                                                                      LONG VARCHAR
    _______________________________________________________________________________
    
    http://www.w3.org/1999/02/22-rdf-syntax-ns#type                                   http://www.w3.org/1999/02/22-rdf-syntax-ns#type                                   http://www.w3.org/1999/02/22-rdf-syntax-ns#Property
    
    1 Rows. -- 0 msec.
    
    real	0m0.006s
    user	0m0.002s
    sys	0m0.002s
    De-iMac-2692:~ hwilliams$
    

    Note the Virtuoso profile function can provide the query compilation and execution times in the Virtuoso engine as detailed in the How can I get full explain and profile plans for a simple SPARQL query documentation.

discourse:reply_count
  • 0
author
is topic of
is has reply of
Faceted Search & Find service v1.17_git55 as of Mar 01 2021


Alternative Linked Data Documents: ODE     Content Formats:       RDF       ODATA       Microdata      About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3322 as of Mar 14 2022, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (7 GB total memory)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software