Re: [Virtuoso-users] update a million triples graph

2011-02-13 Thread Kingsley Idehen
On 2/12/11 1:21 PM, bin chen wrote: 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 ; Fine. Did you then run: select * from where {?s ?p ?o} and then delete .trx under the db directory and

Re: [Virtuoso-users] update a million triples graph

2011-02-12 Thread bin chen
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 ; 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 wo

Re: [Virtuoso-users] update a million triples graph

2011-02-12 Thread Kingsley Idehen
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

[Virtuoso-users] update a million triples graph

2011-02-12 Thread bin chen
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 g