Re: [sqlite] PRAGMA cache_size=0 increases memory usage

Hi Bob, Den 18 maj 2017 9:15 em skrev "Bob Friesenhahn" < bfrie...@simple.dallas.tx.us>: On Thu, 18 May 2017, Kim Gräsman wrote: > >> The request is issued early on when the connection is first opened so no >> actual queries have been issued at that time. >> > > Then my (black-box) guess is

Re: [sqlite] PRAGMA cache_size=0 increases memory usage

On Thu, 18 May 2017, Kim Gräsman wrote: The request is issued early on when the connection is first opened so no actual queries have been issued at that time. Then my (black-box) guess is that you're seeing the bump from allocating heap space for whatever structures the schema needs. Our

Re: [sqlite] PRAGMA cache_size=0 increases memory usage

On Thu, May 18, 2017 at 8:27 PM, Bob Friesenhahn wrote: > On Thu, 18 May 2017, Kim Gräsman wrote: > >> On Thu, May 18, 2017 at 6:10 PM, Bob Friesenhahn >> wrote: >>> >>> Does anyone know why using 'PRAGMA cache_size=0' (or some other

Re: [sqlite] PRAGMA cache_size=0 increases memory usage

On Thu, 18 May 2017, Kim Gräsman wrote: On Thu, May 18, 2017 at 6:10 PM, Bob Friesenhahn wrote: Does anyone know why using 'PRAGMA cache_size=0' (or some other small value) to attempt to decrease memory usage (and it is reported as immediately decreased in the

Re: [sqlite] PRAGMA cache_size=0 increases memory usage

On Thu, May 18, 2017 at 6:10 PM, Bob Friesenhahn wrote: > Does anyone know why using 'PRAGMA cache_size=0' (or some other small value) > to attempt to decrease memory usage (and it is reported as immediately > decreased in the shell by .stats) actually significantly

Re: [sqlite] PRAGMA cache_size=0 increases memory usage

On Thu, 18 May 2017, Simon Slavin wrote: On 18 May 2017, at 5:10pm, Bob Friesenhahn wrote: Does anyone know why using 'PRAGMA cache_size=0' (or some other small value) to attempt to decrease memory usage (and it is reported as immediately decreased in the

Re: [sqlite] PRAGMA cache_size=0 increases memory usage

On 18 May 2017, at 5:10pm, Bob Friesenhahn wrote: > Does anyone know why using 'PRAGMA cache_size=0' (or some other small value) > to attempt to decrease memory usage (and it is reported as immediately > decreased in the shell by .stats) actually significantly

Re: [sqlite] PRAGMA cache_size = 0

B V, Phanisekhar wrote: What exactly happens when I change the cache_size (both increase and decrease size)? A variable is set. It seems this term is a misnomer. What are we achieving by setting this variable? [...] Will there be any memory that will be freed up when I reduce the size

RE: [sqlite] PRAGMA cache_size = 0

>> What exactly happens when I change the cache_size (both increase and >> decrease size)? > A variable is set. It seems this term is a misnomer. What are we achieving by setting this variable? This is what is mentioned in the documentation of SQLITE: PRAGMA cache_size; PRAGMA cache_size =

Re: [sqlite] PRAGMA cache_size = 0

> What exactly happens when I change the cache_size (both increase and > decrease size)? A variable is set. > What happens to the data that's there in the result cache at the time > when the instruction PRAGMA cache_size = 0 is executed? Nothing. The aforementioned variable is set to 10

RE: [sqlite] PRAGMA cache_size = 0

> I tried to set the cache size to 0 (after sqlite3_open0, and then query > for pragma cache_size which returns 2000 (default cache size). Why its > not returning 10 (according to Weiyang Wang)? It does report 0, even though internally it is using a value of 10. SQLite version 3.3.17 Enter

RE: [sqlite] PRAGMA cache_size = 0

: Tuesday, June 12, 2007 3:40 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] PRAGMA cache_size = 0 "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote: > I am yet to get answers for the following questions. > Weiyang Wang correctly answered your question at http://www.mail-ar

RE: [sqlite] PRAGMA cache_size = 0

? Regards, Phani -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 3:40 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] PRAGMA cache_size = 0 "B V, Phanisekhar" <[EMAIL PROTECTED]> wrote: > I am yet to get answer

Re: [sqlite] PRAGMA cache_size = 0

"B V, Phanisekhar" <[EMAIL PROTECTED]> wrote: > I am yet to get answers for the following questions. > Weiyang Wang correctly answered your question at http://www.mail-archive.com/sqlite-users%40sqlite.org/msg25290.html -- D. Richard Hipp <[EMAIL PROTECTED]>

RE: [sqlite] PRAGMA cache_size = 0

I am yet to get answers for the following questions. > What happens if I set the cache_size to 0? Will I be able to do any of > update/delete/insert/select operations? > > When I set the cache_size to 0, is there any freeing up of memory by > sqlite? Regards, Phani

Re: [sqlite] PRAGMA cache_size = 0

correct my former message, the smallest is 10, (10 pages in ram) On 6/11/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote: What happens if I set the cache_size to 0? Will I be able to do any of update/delete/insert/select operations? When I set the cache_size to 0, is there any freeing up of

Re: [sqlite] PRAGMA cache_size = 0

the smallest cache_size is 512k, i guess. On 6/11/07, B V, Phanisekhar <[EMAIL PROTECTED]> wrote: What happens if I set the cache_size to 0? Will I be able to do any of update/delete/insert/select operations? When I set the cache_size to 0, is there any freeing up of memory by sqlite?