[Virtuoso-users] How can I profile stored procedures?

[Davis, Daniel (NIH/NLM) [C]]

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
https://lists.sourceforge.net/lists/listinfo/virtuoso-users