Hi, Kingsley,
I am not allowed to delete the db file cause we have other graphs there (the
size of db upto 14GB). I first run:
sparql clear graph <GraphIRI> ;
and then delete .trx under the db directory and then restart virtuoso.
I update the deleted graph using ld_dir and rdf_loader_run (), it does not
work, here is a copy of the command:
Done. -- 52 msec.
SQL> rdf_loader_run ();
Done. -- 1 msec.
Thanks,
Bin
On Sat, Feb 12, 2011 at 8:31 AM, Kingsley Idehen <kide...@openlinksw.com>wrote:
> On 2/12/11 9:52 AM, bin chen wrote:
>
> Hi,
>
> I have a huge graph to update. I first deleted the graph using the
> following command:
>
> delete from DB.DBA.RDF_QUAD where G =DB.DBA.RDF_MAKE_IID_OF_QNAME
> ("graphname');
>
> then using
> ld_dir and rdf_loader_run ();
>
> it finished within a second, but the data was not uploaded at all, so I
> guess the graph name is still not fully deleted...
> I looked the table DB.DBA.load_list has the graphname, then I deleted it,
> and reran the uploading again, but several days past, it has not completed?
> I guess there are some problems.
>
> I want to know how long it will take to upload a million triples graph?
> what's the best way to update a graph? thanks.
>
>
> Clear the graph using this command from the iSQL commandline editor or
> Conductor UI:
>
> sparql clear graph <GraphIRI> ;
>
> Shorter cut, delete your .db and .trx files, and restart Virtuoso.
>
> Kingsley
>
> Bin
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit
> performance.http://p.sf.net/sfu/intel-dev2devfeb
>
>
> _______________________________________________
> Virtuoso-users mailing
> listVirtuoso-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
> --
>
> Regards,
>
> Kingsley Idehen
> President & CEO
> OpenLink Software
> Web: http://www.openlinksw.com
> Weblog: http://www.openlinksw.com/blog/~kidehen
> Twitter/Identi.ca: kidehen
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
--
Bin Chen
PHD student, Informatics,
Indiana University at Bloomington
http://cheminfo.informatics.indiana.edu/~binchen
