On Friday, 27 December, 2019 16:37, Simon Slavin wrote:
>On 27 Dec 2019, at 9:57pm, Keith Medcalf wrote:
>> Setting "SINGLETHREAD" does indeed disable the multithreaded sorters.
>> When in one of the multithreaded modes, that query utilizes an average of
>> 60% CPU, compared to 12% when runnin
Another point being, fully normalized data can be a bear to extract.
I see penalities in my humble database reports, so I leave 3rd and 4th
normalization for managers wish lists. ;)
On Fri, Dec 27, 2019, 6:37 PM Simon Slavin wrote:
> On 27 Dec 2019, at 9:57pm, Keith Medcalf wrote:
>
> > Setting
On 27 Dec 2019, at 9:57pm, Keith Medcalf wrote:
> Setting "SINGLETHREAD" does indeed disable the multithreaded sorters. When
> in one of the multithreaded modes, that query utilizes an average of 60% CPU,
> compared to 12% when running singlethreaded.
So if I understand this right, SQLite in
On Friday, 27 December, 2019 14:19, Simon Slavin wrote:
>On 27 Dec 2019, at 7:46pm, Keith Medcalf wrote:
>> Setting "SINGLE THREADED" mode *increased* the elapsed time to 4
>minutes. (Perhaps it disables some of the internal multithreaded sorters
>-- I don't know).
>Can anyone explain this ?
On 27 Dec 2019, at 7:46pm, Keith Medcalf wrote:
> Setting "SINGLE THREADED" mode *increased* the elapsed time to 4 minutes.
> (Perhaps it disables some of the internal multithreaded sorters -- I don't
> know).
Can anyone explain this ?
(To save you reading all the stuff I snipped, it's one
On Friday, 27 December, 2019 10:29, Cecil Westerhof
wrote:
>Op vr 27 dec. 2019 om 17:01 schreef Simon Slavin :
>> On 27 Dec 2019, at 3:06pm, Cecil Westerhof wrote:
>>> My applications only use one thread (for the db stuff). Would it be a
>>> good idea to switch to single-thread mode, or does
Op vr 27 dec. 2019 om 17:01 schreef Simon Slavin :
> On 27 Dec 2019, at 3:06pm, Cecil Westerhof wrote:
>
> > My applications only use one thread (for the db stuff). Would it be a
> good idea to switch to single-thread mode, or does that not give a real
> performance improvement?
>
> On a desktop
On 27 Dec 2019, at 3:06pm, Cecil Westerhof wrote:
> My applications only use one thread (for the db stuff). Would it be a good
> idea to switch to single-thread mode, or does that not give a real
> performance improvement?
On a desktop computer, or a mobile phone, the increase in speed is not
My applications only use one thread (for the db stuff). Would it be a good
idea to switch to single-thread mode, or does that not give a real
performance improvement?
If the performance is not really improved, I can better keep the default.
Then there is no risk that I forget the change the mode wh
9 matches
Mail list logo