Also: $ virtuoso-t -? Virtuoso Open Source Edition (multi threaded) Version 6.1.6.3127-pthreads as of Nov 20 2012 Compiled for Linux (x86_64-pc-linux-gnu)
On 14 June 2013 11:47, Quentin <[email protected]> wrote: > I have a problem that I solved but I'm still not sure why it occurred. > > Our application is updating a small number of triples with the below > query, constructed in code rather than hand-written. > > delete from graph < > http://example.com/datasets/myProject/widgets/1631784244/> { > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/title> ?o0 . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/xAxisColumn> ?o1 . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/chartType> ?o2 . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/category> ?o3 . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/name> ?o4 . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/chartLevel> ?o5 . > } where { > optional { <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/title> ?o0 . } > optional { <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/xAxisColumn> ?o1 . } > optional { <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/chartType> ?o2 . } > optional { <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/category> ?o3 . } > optional { <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/name> ?o4 . } > optional { <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/chartLevel> ?o5 . } > } > insert into graph < > http://example.com/datasets/myProject/widgets/1631784244/> { > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/title> "Report Name" . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/xAxisColumn> "AxisName" . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/chartType> "column" . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/category> "UserDefinedReports" . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/name> "Report Name" . > <http://example.com/data/myProject/5163c11f07720918117864> < > http://example.com/ontology/sdr/chartLevel> "" . > } > > When this query is performed in conductor, it times out. When performed > by odbc then it succeeds but takes about 12m40s to execute. > > Refactoring as a WITH <graph> DELETE {...} INSERT {...} WHERE {...} using > exactly the same patterns above, it all works in under a second. > > What's the difference there? Is there an error in the first example that > is causing poor behaviour? > > I've looked at the explain plans for the two versions though I find them > difficult to interpret. > -- > Quentin | Clear Blue Water Pty Ltd > [email protected] > -- Quentin | Clear Blue Water Pty Ltd [email protected]
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
