Just to confirm that if sqlite3.dll is compiled with
DSQLITE_DEFAULT_PCACHE_INITSZ=0
I can also see memory being released here.
So, that was indeed it.
RBS
On Thu, Jan 7, 2016 at 11:04 PM, Scott Hess wrote:
> Hmm. I see that sqlite3PcacheReleaseMemory() is a no-op
> if sqlite3GlobalConfig.nP
Thanks for that. Will look into this. Looks you might be onto something
there.
RBS
On Thu, Jan 7, 2016 at 11:04 PM, Scott Hess wrote:
> Hmm. I see that sqlite3PcacheReleaseMemory() is a no-op
> if sqlite3GlobalConfig.nPage is non-zero, and that happens
> when SQLITE_DEFAULT_PCACHE_INITSZ is no
Hmm. I see that sqlite3PcacheReleaseMemory() is a no-op
if sqlite3GlobalConfig.nPage is non-zero, and that happens
when SQLITE_DEFAULT_PCACHE_INITSZ is not zero. If I compile with
-DSQLITE_DEFAULT_PCACHE_INITSZ=0 , then I see the expected pages freed.
AFAICT, it doesn't matter if you make use of
These are the compile flags of my sqlite3.dll:
compile_option
DEBUG
ENABLE_COLUMN_METADATA
ENABLE_MEMORY_MANAGEMENT
MEMDEBUG
OMIT_LOOKASIDE
THREADSAFE=0
And these are the set pragma's:
PRAGMA cache_size 32768
PRAGMA default_cache_size 32768
PR
> So you should
see results if you start a transaction, do a few update statements, commit
the transaction, the call sqlite3_release_memory(db).
I tried this with a large table, first with no transaction then with a
transaction
and tried the sqlite3_release_memory directly after the sqlite3_finali
OK, will try that.
sqlite3_release_memory doesn't have the DB connection as an argument, but
found
sqlite3_db_release_memory and that has that as an argument and that may
work better.
RBS
On Thu, Jan 7, 2016 at 6:05 AM, Scott Hess wrote:
> On Wed, Jan 6, 2016 at 3:03 PM, Bart Smissaert
> wrote
In that case - oops. I definitely was experimenting with the db-centric
version. It looks to me like the lowest-level mechanism is similar between
the two, but sqlite3_db_release_memory() isn't optionally compiled.
-scott
On Thu, Jan 7, 2016 at 12:32 AM, Bart Smissaert
wrote:
> OK, will try
Have compiled sqlite3.dll (latest) compiled with ENABLE_MEMORY_MANAGEMENT,
but sofar
not been able yet to make sqlite3_release_memory produce anything else than
0.
What would be the simplest way to make this happen?
I don't want to do this with C coding, so it should be some SQL scenario or
to do w
On Wed, Jan 6, 2016 at 3:03 PM, Bart Smissaert
wrote:
> Have compiled sqlite3.dll (latest) compiled with ENABLE_MEMORY_MANAGEMENT,
> but sofar
> not been able yet to make sqlite3_release_memory produce anything else than
> 0.
> What would be the simplest way to make this happen?
> I don't want to
Can someone stear me to a good tutorial to setup and use with windows computer
and visual sudio 2008
Tham\nks
- Original Message -
From: Bart Smissaert
Reply-To: SQLite mailing list
To: General Discussion of SQLite Database
Sent: 1/6/2016 5:03:55 PM
Subject: [sqlite] How to make
10 matches
Mail list logo