[sqlite] Limiting the amount of memory usage for Sqlite

I will be great if someone can help me on how to limit the amount of memory usage to a fixed size for Sqlite version 3.3.6. At present the amount of memory usage increases when the number of objects inserted into the database is increased. I want to set a maximum allowable limit for the memory

Re: [sqlite] Limiting the amount of memory usage for Sqlite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gokila Dorai wrote: > I will be great if someone can help me on how to limit the amount of memory > usage to a fixed size for Sqlite version 3.3.6. Look closer at the source code. You can provide your own memory functions and tuning. They have chan

Re: [sqlite] Limiting the amount of memory usage for Sqlite

Hi, Thanks for the reply. I have some more clarifications: 1. I tried using the sqlite3_soft_heap_limit(N) and sqlite3_release_memory() APIs. I complied using the following option: "$gcc -o EXENAME filename.c -lsqlite3 -DSQLITE_ENABLE_MEMORY_MANAGMENT=1" This resulted in linkage error sayin

Re: [sqlite] Limiting the amount of memory usage for Sqlite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gokila Dorai wrote: > Please let me know whether the linker I am using is wrong, or have I missed > out something here. What is the alternative to this? The alternative is to use whatever APIs were available in that old version of SQLite. You'll have