2016-04-17 21:59 GMT+02:00 Scott Robison <scott at casaderobison.com>:
> 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). > ?That I know, but I was only going for big O. I really did not expect differences like I am getting now. Well, I learned something.? > It's entirely possible that the table drop is related to something similar > to this. > ?I can give positive news about this. In DB Browser it now took 20 seconds. The strange thing is that Revert Changes took much longer. I did not expect this, so sadly I do not have timing for this. The Java program took 2 minutes and 5 seconds. But this was with Firefox running. (I have some things to do.) Inserting goes a lot faster: 21:56:59: Going to create 1.00e+08 random UUID's 21:57:26: Inserted 1.00e+06 UUID's 21:58:06: Inserted 2.00e+06 UUID's 21:58:51: Inserted 3.00e+06 UUID's 21:59:40: Inserted 4.00e+06 UUID's 22:00:31: Inserted 5.00e+06 UUID's 22:01:32: Inserted 6.00e+06 UUID's 22:02:37: Inserted 7.00e+06 UUID's 22:03:47: Inserted 8.00e+06 UUID's 22:04:52: Inserted 9.00e+06 UUID's 22:06:20: Inserted 1.00e+07 UUID's 22:07:58: Inserted 1.10e+07 UUID's 22:09:35: Inserted 1.20e+07 UUID's 22:11:18: Inserted 1.30e+07 UUID's But it is possible that this has to do with the commits I do. Just before displaying I do a commit, instead of after all the work is done. Using the sqlite3 executable took 2 minutes. That makes the 20 seconds of DB Browser a little strange. Well, I have to do everything over this week on a system that is not doing anything else. -- Cecil Westerhof
