Cecil, If you have a load average of 15 then that normally means you have a massively overloaded Linux box. I don?t know your system but I get worried around a load average of 3-4 on our boxes. Load Average is a very crude measurement but a high number tends to be bad.
If your CPU is only running at 15% (how do you know this?) then the problem is likely elsewhere. My first thought is swap space, check what the disk io is, the fact you mention Java would immediately make me look at the amount of memory allocated to the JVM. For some reason many JVM?s allocate a pitifully small amount of memory, Java then runs out of memory pretty quickly and spends the next few secs/mins/hours fighting with the OS for resources. Top, netstat, ps etc are your friends here. You need to look at them and see whats kicking your load average into the stratosphere. I?d be surprised if its Sqlite, we don?t normally drop tables, but from memory, dropping a 10GB table took no time. It might have been seconds or a minute, we didn?t measure it as it wasn?t an issue. Rob On 16 Apr 2016, at 20:25, Cecil Westerhof wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
