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

Reply via email to