2016-04-16 20:36 GMT+02:00 R Smith <rsmith at rsweb.co.za>: > > > On 2016/04/16 3:39 PM, Cecil Westerhof wrote: > >> 2016-04-16 14:52 GMT+02:00 R Smith <rsmith at rsweb.co.za>: >> >> Let me try the 100 million rows, this may take some time - I will post >>> again when it is done. >>> >>> ?I am curious. >> > > Well, here it is then, 100-million rows: The INSERT took a lot of time, > near 5 hours, but again, the DROP was only a few seconds. >
?That is what I would expect, but not what I see. :'-( I am filling the database again, but now with text UUID instead of blob UUID. That takes a ?little? more time. When it is filled I try again. Have another problem also. My CPU is about 15%, but the load average is also about 15. (This is on a Linux system.) This results (sometimes) in a very sluggish system. Can the load be a SQLite problem, or is it a Java problem? (When the program is not running, the load average is a lot lower.) -- Cecil Westerhof
