Re: [Virtuoso-users] When is a bulk load done?

2014-04-21 Thread Paul Houle
Well I am watching my Virtuoso instance right now and even though all the rows have been in state 2 for at least an hour I am still observing a load average of 1.14 thanks to Virtuoso CPU and disk activity. So something is still going on although the load is "done". I've seen this behavior on an

Re: [Virtuoso-users] When is a bulk load done?

2014-04-21 Thread Hugh Williams
Hi Paul, Using the Virtuoso RDF Bulk Loader (rdf_loader_run) as you appear to be, the load is complete when all files in the load_list table have an "ll_state" = 2 , 0 means still to be loaded, 1 means load is in progress. What does the "status()" command report when the load rate slows as I

[Virtuoso-users] When is a bulk load done?

2014-04-21 Thread Paul Houle
The image below is a trace of the CPU consumption of a bulk load I did in Virtuoso. https://raw.githubusercontent.com/paulhoule/images/master/CpuForVirtuosoLoad.PNG Here I am loading half a billion or so triples in Amazon EC2 using an r3.xlarge, with Virtuoso running on the instance storage SSD.