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

Reply via email to