On Sun, Apr 17, 2016 at 1:44 PM, Cecil Westerhof <cldwesterhof at gmail.com> wrote:
> 2016-04-17 18:13 GMT+02:00 Cecil Westerhof <cldwesterhof at gmail.com>: > > > 2016-04-17 17:13 GMT+02:00 Keith Medcalf <kmedcalf at dessus.com>: > > The strange thing is that the blob variant takes a lot of time now also. > > First it took only 4? hour, now it is already busy for eight hours and > only > > has come to 8.9E7. > > > > 14:36:01: Inserted 8.40e+07 UUID's > > 14:54:47: Inserted 8.50e+07 UUID's > > 15:30:19: Inserted 8.60e+07 UUID's > > 15:54:02: Inserted 8.70e+07 UUID's > > 16:17:01: Inserted 8.80e+07 UUID's > > 17:24:20: Inserted 8.90e+07 UUID's > > > > ?It turned out that it is a combination of factors. Firefox sometimes takes > a lot of resources, so I decided to quit Firefox. And voila:? > 17:24:20: Inserted 8.90e+07 UUID's > 18:28:02: Inserted 9.00e+07 UUID's > 19:24:13: Inserted 9.10e+07 UUID's > 19:36:41: Inserted 9.20e+07 UUID's > 19:42:18: Inserted 9.30e+07 UUID's > 19:47:46: Inserted 9.40e+07 UUID's > 19:52:43: Inserted 9.50e+07 UUID's > 19:57:50: Inserted 9.60e+07 UUID's > 20:02:36: Inserted 9.70e+07 UUID's > 20:07:29: Inserted 9.80e+07 UUID's > 20:12:17: Inserted 9.90e+07 UUID's > 20:16:59: Inserted 1.00e+08 UUID's > > I should continue this on a Linux/Java newsgroup. But I thought it was > interesting to know. > It can be hard to accurately measure performance on a modern multitasking multiuser system. As you've observed, external processes can have a huge impact of the "independent and isolated" process. Whenever I'm trying to measure performance, I close all other applications, maybe disconnect from the network, turn off services. Depending on just how accurate I want to be with the measurement (not all measurements are as important / picky). It's entirely possible that the table drop is related to something similar to this. -- Scott Robison On Sun, Apr 17, 2016 at 1:44 PM, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > 2016-04-17 18:13 GMT+02:00 Cecil Westerhof <cldwesterhof at gmail.com>: > > > 2016-04-17 17:13 GMT+02:00 Keith Medcalf <kmedcalf at dessus.com>: > > The strange thing is that the blob variant takes a lot of time now also. > > First it took only 4? hour, now it is already busy for eight hours and > only > > has come to 8.9E7. > > > > 14:36:01: Inserted 8.40e+07 UUID's > > 14:54:47: Inserted 8.50e+07 UUID's > > 15:30:19: Inserted 8.60e+07 UUID's > > 15:54:02: Inserted 8.70e+07 UUID's > > 16:17:01: Inserted 8.80e+07 UUID's > > 17:24:20: Inserted 8.90e+07 UUID's > > > > ?It turned out that it is a combination of factors. Firefox sometimes takes > a lot of resources, so I decided to quit Firefox. And voila:? > 17:24:20: Inserted 8.90e+07 UUID's > 18:28:02: Inserted 9.00e+07 UUID's > 19:24:13: Inserted 9.10e+07 UUID's > 19:36:41: Inserted 9.20e+07 UUID's > 19:42:18: Inserted 9.30e+07 UUID's > 19:47:46: Inserted 9.40e+07 UUID's > 19:52:43: Inserted 9.50e+07 UUID's > 19:57:50: Inserted 9.60e+07 UUID's > 20:02:36: Inserted 9.70e+07 UUID's > 20:07:29: Inserted 9.80e+07 UUID's > 20:12:17: Inserted 9.90e+07 UUID's > 20:16:59: Inserted 1.00e+08 UUID's > > I should continue this on a Linux/Java newsgroup. But I thought it was > interesting to know. > > Now I can continue with where I started this tread for. ;-) > > -- > Cecil Westerhof > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison