On Fri, Dec 7, 2012 at 11:09 PM, Kingsley Idehen <[email protected]>wrote:

> SPARQL 1.1 Update language includes DELETE option :-)


Thanks. I managed.

I had been trying "sparql insert { .. } delete { .. }". The correct syntax
was "sparql delete { .. } insert { .. }".

I am a little concerned about the execution time. Preliminary (read really
stupid) tests show a lot of difference -

SQL> sparql delete { graph
<nepomuk:/ctx/e6990720-8f63-45e2-9bc7-3fe8d3a67835> {
<nepomuk:/res/4596e939-dfbd-4d9f-8406-7a546fde8980> <
http://nepomuk.kde.org/ontologies/2010/11/29/kext#unixFileMode> "33188"^^<
http://www.w3.org/2001/XMLSchema#int> .}  } insert { graph
<nepomuk:/ctx/4beb2f29-852d-467c-b22e-f2b34df8197b> {
<nepomuk:/res/4596e939-dfbd-4d9f-8406-7a546fde8980> <
http://nepomuk.kde.org/ontologies/2010/11/29/kext#unixFileMode> "33188"^^<
http://www.w3.org/2001/XMLSchema#int> . } };

Done. -- 20 msec.
SQL>
SQL>
SQL> sparql select ?g where { graph ?g {
<nepomuk:/res/4596e939-dfbd-4d9f-8406-7a546fde8980> <
http://nepomuk.kde.org/ontologies/2010/11/29/kext#unixFileMode> "33188"^^<
http://www.w3.org/2001/XMLSchema#int> . } };
g
VARCHAR
_______________________________________________________________________________

nepomuk:/ctx/4beb2f29-852d-467c-b22e-f2b34df8197b

1 Rows. -- 1 msec.
SQL> sparql insert { graph
<nepomuk:/ctx/e6990720-8f63-45e2-9bc7-3fe8d3a67835> {
<nepomuk:/res/4596e939-dfbd-4d9f-8406-7a546fde8980> <
http://nepomuk.kde.org/ontologies/2010/11/29/kext#unixFileMode> "33188"^^<
http://www.w3.org/2001/XMLSchema#int> . } };

Done. -- 2 msec.
SQL>
SQL> sparql delete { graph
<nepomuk:/ctx/4beb2f29-852d-467c-b22e-f2b34df8197b> {
<nepomuk:/res/4596e939-dfbd-4d9f-8406-7a546fde8980> <
http://nepomuk.kde.org/ontologies/2010/11/29/kext#unixFileMode> "33188"^^<
http://www.w3.org/2001/XMLSchema#int> .}  }
Type the rest of statement, end with a semicolon (;)> ;

Done. -- 2 msec.


A combined delete + insert took around 20msec. When separate delete +
insert statements took 2 msecs each.

Anyway, I'll run some proper tests on a large data set and compare the
actual benchmarks to see if there is any difference. Thank you, for your
help.

-- 
Vishesh Handa
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to