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 Virtuoso/PL procedure then they're between SPARQL keyword and the SPARQL query itself. Best Regards, Ivan Mikhailov OpenLink Software http://virtuoso.openlinksw.com > 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 graph. > > > Regards, > Alexander > > 2011/6/9 Hugh Williams <[email protected]> > 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 > operation > (and restore the log mode back to original value after the > operation). > The log_enable() BIF is described in > http://docs.openlinksw.com/virtuoso/fn_log_enable.html > >>> > > Is this still the same or similar issue ? > > What version of Virtuoso are you running currently (virtuoso-t > -?) ? > > What is the size in triple count of the graph(s) being > clear’ed ? > > In your query below you are counting the number of graphs, but > clear graph does not remove a graph it just clears its > content so the graph count will remain the same, but the key > is has the over all triple count reduced ( ie select count(*) > where {?s ?p ?o}) ? If the graphs where explicitly created > then you can use “drop graph <graph-name>” instead to remove > it, although even that needs some explaining in terms of the > differences between create, drop, clear and delete Graph as > detailed at: > > > > http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksGuideCreateGraph > > The database size will not reduce when you remove content as > once pages are allocated they are not returned. If running v6 > you can try running the vacuum() function which will perform > some compact of the database as detailed at: > > http://docs.openlinksw.com/virtuoso/fn_vacuum.html > > Best Regards > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Support: http://support.openlinksw.com > Forums: http://boards.openlinksw.com/support > Twitter: http://twitter.com/OpenLink > > > On 9 Jun 2011, at 16:39, Alexander Sidorov wrote: > > > 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? > > > > Regard, > > Alexander
