Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

2011-02-21 Thread Todd Shutts
Sent: Sunday, February 20, 2011 7:48 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/20/2011 02:48 PM, Todd Shutts wrote: > However; memory usage is growing like crazy. It is a ve

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

2011-02-21 Thread Simon Slavin
On 21 Feb 2011, at 5:56am, Dan Kennedy wrote: > WAL file growth has (apparently) been a problem for people with > really busy systems. But so far it has been the actual size of > the file on disk that bothers them, not the memory mapped bit. If that's what you think is raising concern then fine,

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

2011-02-20 Thread Dan Kennedy
On 02/21/2011 09:38 AM, Simon Slavin wrote: > > On 21 Feb 2011, at 1:47am, Roger Binns wrote: > >> On 02/20/2011 02:48 PM, Todd Shutts wrote: >>> The application >>> never used more than 10MB and it is currently using 57+MB and continues >>> to climb. >> >> The single most likely explanation is thi

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

2011-02-20 Thread Simon Slavin
On 21 Feb 2011, at 1:47am, Roger Binns wrote: > On 02/20/2011 02:48 PM, Todd Shutts wrote: >> The application >> never used more than 10MB and it is currently using 57+MB and continues >> to climb. > > The single most likely explanation is this is WAL in action, the memory is > from a memory m

Re: [sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

2011-02-20 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/20/2011 02:48 PM, Todd Shutts wrote: > However; memory usage is growing like crazy. It is a very frequent occurrence that what people think is being measured is not what is actually being measured. Make sure you understand exactly what the too

[sqlite] Upgrade from 3.5.8 -> 3.7.5 - increase memory usage

2011-02-20 Thread Todd Shutts
I inherited an application which used SQLite 3.5.8 running on Windows 2000. I upgrade to version 3.7.5 of the dll and added pragma statement to use WAL. There was an immediate and significant performance increase. However; memory usage is growing like crazy. The application never used more tha