[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-05 Thread R Smith
On 2016/02/04 3:30 PM, Keith Medcalf wrote: > You conclusion about the Windows design goals are correct. > > Hardware Destroyer (power saving) was invented for the same reason (to > maximize the rate of hardware failure through imposition of unnecessary > thermal and mechanical stresses on all

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-04 Thread Bernardo Sulzbach
I don't really care about all the MS hate, but will add mine[1]. I am not a participant of that question, but it shows the same problem. I had over 50% CPU usage for hours when the computer was "idle" because Windows was indexing my stuff, forever. A friend of mine had the same problem and after

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-04 Thread Random Coder
On Wed, Feb 3, 2016 at 3:53 PM, Howard Chu wrote: > No. Windows will toss clean pages out even in the total absence of memory > pressure. It is moronic, but true. You can repeat the steps I outlined for > yourself and see. > >

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-04 Thread Keith Medcalf
ednesday, 3 February, 2016 16:53 > To: SQLite mailing list > Subject: Re: [sqlite] IS a SQLite db of small size as good as reliable > cache? > > GB wrote: > > So where have you got this wisdom from? It's just plain Bullshit! > > > > Just as most cache managers do, Windows

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-03 Thread Howard Chu
GB wrote: > So where have you got this wisdom from? It's just plain Bullshit! > > Just as most cache managers do, Windows cache manager uses some sort of LRU > caching scheme. So all data once read from file is kept in memory until either > some memory pressure occurs or it is simply pushed out by

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-03 Thread Yannick DuchĂȘne
On Wed, 3 Feb 2016 23:25:33 +0100 GB wrote: > So where have you got this wisdom from? It's just plain Bullshit! > > Just as most cache managers do, Windows cache manager uses some sort of > LRU caching scheme. So all data once read from file is kept in memory > until either some memory

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-03 Thread GB
So where have you got this wisdom from? It's just plain Bullshit! Just as most cache managers do, Windows cache manager uses some sort of LRU caching scheme. So all data once read from file is kept in memory until either some memory pressure occurs or it is simply pushed out by newer data.

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-02 Thread James K. Lowden
On Mon, 01 Feb 2016 06:39:05 -0700 "Keith Medcalf" wrote: > OS/2 had IBM cache technology in it which worked properly. I remember OS/2. I remember that, like VMS, you could back up the whole OS to ... well, floppies, I suppose, and later restore them to brand new drive, with nothing else

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-01 Thread Wade, William
-Original Message- From: Howard Chu [mailto:h...@symas.com] Sent: Saturday, January 30, 2016 4:23 PM To: SQLite mailing list Subject: Re: [sqlite] IS a SQLite db of small size as good as reliable cache? The Windows cache manager is quite aggressive at evicting cached pages from RAM. It used

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-01 Thread Keith Medcalf
> > Any insight into what they were thinking? Back when I used Windows > > daily, it used to annoy me that every morning the machine had to warm > > up again, to revive the state I'd left it in the night before. In > > NetBSD I learned that unused memory is unused, so why not use it? The file

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-02-01 Thread Howard Chu
James K. Lowden wrote: > On Sat, 30 Jan 2016 22:23:24 + > Howard Chu wrote: > >> Note that the cache eviction runs quite frequently - once every 5 >> seconds or so, and evicts pages regardless of whether there's any >> memory pressure in the system. It's quite possibly the stupidest >> cache

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-01-31 Thread Simon Slavin
> On 31 Jan 2016, at 11:24pm, James K. Lowden > wrote: > > Howard Chu wrote: > >> Note that the cache eviction runs quite frequently - once every 5 >> seconds or so, and evicts pages regardless of whether there's any >> memory pressure in the system. It's quite possibly the stupidest >>

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-01-31 Thread James K. Lowden
On Sat, 30 Jan 2016 22:23:24 + Howard Chu wrote: > Note that the cache eviction runs quite frequently - once every 5 > seconds or so, and evicts pages regardless of whether there's any > memory pressure in the system. It's quite possibly the stupidest > cache manager ever written. Any

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-01-31 Thread dpb
Dear Community, Assuming that SQLite would arrange the database table contents on page boundary and 1) if db is small let us say maximum 5MB, 2 further if such a db is part of windows service / application running continuously then may be pages will remain in the memory under normal

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-01-30 Thread Jean-Christophe Deschamps
At 22:57 30/01/2016, you wrote: >2 further if such a db is part of windows service / application running >continuously then may be pages will remain in the memory under normal >conditions. > >Q1) Operating System like Windows would cache the series of pages, is this >behavior not almost same as

[sqlite] IS a SQLite db of small size as good as reliable cache?

2016-01-30 Thread Howard Chu
dpb wrote: > Dear Community, > > Assuming that SQLite would arrange the database table contents on page > boundary and > > 1) if db is small let us say maximum 5MB, > > 2 further if such a db is part of windows service / application running > continuously then may be pages will remain in the