Hi Daniel,
SQL and SPARQL query profile and execution plans can be obtained by enabled
query logging as detailed at:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#querylogging
<http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#querylogging>
and can be analysed as detailed at:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#readingqueryprofile
<http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#readingqueryprofile>
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 29 Oct 2015, at 15:49, Davis, Daniel (NIH/NLM) [C] <daniel.da...@nih.gov>
> wrote:
>
> How can I profile SQL or SPARQL statements when running this statements
> within a stored procedure?
>
> I’ve refactored my versioning algorithm to use more complicated single
> queries, for example:
>
> LOG_ENABLE(2, 1);
> DELETE FROM RDF_QUAD
> WHERE g = __target_graph
> AND EXISTS (SELECT subject_iid
> FROM msh_update
> WHERE msh_update.graph_iid = RDF_QUAD.g
> AND msh_update.subject_iid = RDF_QUAD.s
> AND status = 1);
>
> LOG_ENABLE(2,1);
> INSERT INTO RDF_QUAD (g, s, p, o)
> SELECT u.graph_iid, u.subject_iid, q.p, q.o
> FROM msh_update u
> JOIN rdf_quad q ON u.subject_iid = q.s
> WHERE u.graph_iid = __target_graph
> AND q.g = __update_graph AND status IN (‘upate’, ‘insert’);
>
> Thanks,
>
> Dan Davis, Systems/Applications Architect (Contractor),
> Office of Computer and Communications Systems,
> National Library of Medicine, NIH
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> <mailto:Virtuoso-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
