RE: RE: [sqlite] DROP INDEX not freeing up memory

2007-01-18 Thread Dave Gierok
, Dave -Original Message- From: Dave Gierok [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 9:06 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] DROP INDEX not freeing up memory OK, thanks, I'll do some more digging and let you know. -Original Message- From: [EMAIL PROTECTED] [

RE: RE: [sqlite] DROP INDEX not freeing up memory

2007-01-18 Thread Ken
: Dave Gierok [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 9:06 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] DROP INDEX not freeing up memory OK, thanks, I'll do some more digging and let you know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

RE: [sqlite] DROP INDEX not freeing up memory

2007-01-18 Thread Ken
To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX not freeing up memory Dave Gierok wrote: > > I am running an in-memory db and am using the functionality where > we override all the OS calls such that we implement our own memory > management and file IO. Therefore, I am able

RE: RE: [sqlite] DROP INDEX not freeing up memory

2007-01-17 Thread Dave Gierok
is quite a bit of memory in our world. Any suggestions or explanations? Thanks, Dave -Original Message- From: Dave Gierok [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 9:06 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] DROP INDEX not freeing up memory OK, thanks, I'll do

Re: [sqlite] DROP INDEX not freeing up memory

2007-01-17 Thread John Stanton
PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX not freeing up memory Sqlite is allocating cache memory and reusing it. That is not a bug, it is a beneficial feature. Dave Gierok wrote: Yes, I did try that -- I should have mentioned it. When I create and drop the index again

RE: [sqlite] DROP INDEX not freeing up memory

2007-01-17 Thread Dave Gierok
OK, thanks, I'll do some more digging and let you know. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 8:30 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX not freeing up memory Dave Gierok <[EMAIL PROTECTED]>

Re: [sqlite] DROP INDEX not freeing up memory

2007-01-17 Thread drh
Dave Gierok <[EMAIL PROTECTED]> wrote: > xTruncate is not being called because this is an in-memory database. Memor= > y databases should have memory freed instead I assume? > In-memory databases call sqliteFree() to release their memory. I checked, and this does appear to work. Perhaps the

Re: [sqlite] DROP INDEX not freeing up memory

2007-01-16 Thread John Stanton
the index once costs a lot of memory, and then future deletions/creations does not change the amount of memory allocated. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 16, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX

Re: [sqlite] DROP INDEX not freeing up memory

2007-01-16 Thread drh
Dave Gierok <[EMAIL PROTECTED]> wrote: > > I am running an in-memory db and am using the functionality where > we override all the OS calls such that we implement our own memory > management and file IO. Therefore, I am able to easily track the > amount of memory Sqlite is taking up. I have

RE: [sqlite] DROP INDEX not freeing up memory

2007-01-16 Thread Dave Gierok
allocated. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 16, 2007 1:56 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] DROP INDEX not freeing up memory Dave Gierok wrote: > (I'm resending this, as I have not seen it posted the first time I s