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 > ------------------------------------------------------------------------------ > EditLive Enterprise is the world's most technically advanced content > authoring tool. Experience the power of Track Changes, Inline Image > Editing and ensure content is compliant with Accessibility Checking. > http://p.sf.net/sfu/ephox-dev2dev_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
