Hello Sebastian,
Unfortunately there's no way to calculate the graph to delete by
something more complicated than constant expression. If that creates
severe problems then I will extend the processor to support something
like
clear graph (
select ?mg where {
?mg
Hi list,
With this query:
clear graph ?mg where {
?mg nrl:coreGraphMetadataFor ?g .
FILTER(?g in (urn:nepomuk:local:8a9e692a)) .
FILTER(
!bif:exists((select (1) where { graph ?g { ?s ?p ?o . } . }))
) .
}
I get the following error:
SP031: SPARQL compiler: non-global
Hi Alexander
log_enable(3,1);
delete from rdf_quad where g = iri_to_id (‘graph-name’);
Note that this will not even try to remove free-text index data for this
graph.
Best Regards,
Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com
log_enable 3 worked like a charm. Graph contains zero triples now. After
that I tried to run vacuum() to make the size of my database less, but after
it had finished its work, the size became even more (was 4.8gb, now 6.8gb).
2011/6/11 Ivan Mikhailov imikhai...@openlinksw.com
Hi Alexander
Hi Alexander,
Glad to hear log_enable worked for you and I have created the following tip for
all’s benefit on how to delete large graphs:
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideDeleteLargeGraphs?
With regards to the vacuum function did you run a
Hi Hugh,
I forgot about that discussion and it really looks like the same problem.
Unfortunately I have no idea how to execute define sql:log-enable NNN
before the query - it doesn't run.
Virtuoso 06.01.3127
About 30kk of triples.
I am pretty sure my query calculates triples count inside a
Hello Alexander,
All DEFINE pragmas are placed right into the SPARQL statement.
They're not in a separate statement, they're part of SPARQL statement.
If it's via web-interface then they're at the very beginning of the
statement,
if it's via ISQL or SPARQL is a part of an bigger SQL query or
Hi Alexander
You can turn transactions off and then back on using the log_enable() function
directly as:
log_enable(3,1);
SPARQL CLEAR GRAPH graph-name;
or as a pragma in the specified query as:
SPARQL DEFINE sql:log-enable 3 CLEAR GRAPH graph-name;
or you can
Hello!
I need to clear some graph from Virtuoso database. I execute sparql clear
graph graphName from isql, virtuoso-t takes all my free memory but the
size of database file doesn't become better and even select count(*) from
graph graphName { ?s ?p ?o} doesn't become less. What am I doind wrong?
Hi Alexander,
Its been a while, but one of the last conversation we had about a year was with
regards to clear graph issues you were having in which Ivan had suggested:
Try define sql:log-enable NNN at the beginning of CLEAR GRAPH
statement. That will invoke log_enable (NNN, 1) before the
Hi Kingsley,
This table raised the question. There is no price for High-memory instances
(but I can choose them during instance launching). Also it is very
disappointing there is no over 96 hours discount for Large instances (I
believe it is the most popular choice).
Regards,
Alexander
11 matches
Mail list logo
