Re: [sqlite] sqlite3_release_memory Question

2008-01-11 Thread Roger Binns
Shawn Wilsher wrote: > That got me looking into sqlite3_release_memory. DRH would need to answer this precisely, but I believe that SQLite will free up almost all memory anyway if you have called sqlite3_close() on all open handles. Roger

Re: [sqlite] sqlite3_release_memory Question

2008-01-11 Thread drh
"Shawn Wilsher" <[EMAIL PROTECTED]> wrote: > Hmm, the documentation (http://sqlite.org/compile.html) doesn't seem > to say anything about [sqlite3_release_memory() only working if > SQLITE_ENABLE_MEMORY_MANAGEMENT=1 is used]. Is there a cost to > pay by enabling those functions, or no? > There

Re: [sqlite] sqlite3_release_memory Question

2008-01-11 Thread Shawn Wilsher
Hmm, the documentation (http://sqlite.org/compile.html) doesn't seem to say anything about that. Is there a cost to pay by enabling those functions, or no? Cheers, Shawn On Jan 11, 2008 8:42 AM, <[EMAIL PROTECTED]> wrote: > "Shawn Wilsher" <[EMAIL PROTECTED]> wrote: > > Hey all, > > > > Over

Re: [sqlite] sqlite3_release_memory Question

2008-01-11 Thread drh
"Shawn Wilsher" <[EMAIL PROTECTED]> wrote: > Hey all, > > Over in Mozilla land, we are looking for ways to free up as much > memory as possible on demand. That got me looking into > sqlite3_release_memory. However, the docs say that it tries to free > up to N bytes, but that it could free more

[sqlite] sqlite3_release_memory Question

2008-01-11 Thread Shawn Wilsher
Hey all, Over in Mozilla land, we are looking for ways to free up as much memory as possible on demand. That got me looking into sqlite3_release_memory. However, the docs say that it tries to free up to N bytes, but that it could free more or less. My question is, how do we get it to free as