Another detail that is relevant is that the SPO pattern exists in about 15
graphs but we're only doing an update to the set of triples in the named
graph.
The background is that we're storing a configured report for a given user
but for convenience we copied that report into the graphs used by a dozen
or so other users without changing the subject. When we want to update a
user's copy of the report, we get this problem.
On 14 June 2013 11:54, Quentin <[email protected]> wrote:
> 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]
>
--
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