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