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 saying "undefined reference to
`sqlite3_soft_heap_limit' ".
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?
To your knowledge, the Fedora sqlite version I am using is 3.3.6. And the
uclinux sqlite version is 3.5.4.
Thanks in advance.
Regards,
Gokila D
Roger Binns wrote:
>
> -----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 changed over the releases.
>
>> At present the amount of
>> memory usage increases when the number of objects inserted into the
>> database
>> is increased.
>
> That would be the cache you seeing. You can use pragmas to alter how
> much memory is used for caching.
>
> Roger
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAkmaaTwACgkQmOOfHg372QQVQgCeM1DuxusUpRYyZS5cSnbnBpEf
> 928An0qFhjyoRzKIXAsKEs6j4iWurS1N
> =4KKT
> -----END PGP SIGNATURE-----
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://www.nabble.com/Limiting-the-amount-of-memory-usage-for-Sqlite-tp22051229p22057981.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
