Re: [Virtuoso-users] O_Direct support in OSes

2011-02-12 Thread Hugh Williams
Hi Abhi, Although O_DIRECT can be enabled for those OS'es that support it, testing performed by development has shown no evidence of performance improvements hosting large databases on any of the OS;es tested on. If testing on Linux their is a kernel configuration called "swappiness" that con

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