Re: [sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Martin Vystrčil
Yes, I can see that SQLite is doing just small allocations using memory methods. I also tried to limit the size of database using following two methods rc = sqlite3_config(SQLITE_CONFIG_HEAP, buffer, 500, 64); if(rc != SQLITE_OK) { printf("Failed to set custom heap

Re: [sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Richard Hipp
On 7/13/18, Martin Vystrčil wrote: > > But still, I would like to solve this somehow, could you please suggest me > some point, where to start ? Are there any possible compilation options, to > limit this allocation ? It is not SQLite that is doing this allocation. I suspect it is something

Re: [sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Martin Vystrčil
Thank you both for help. What Richar Hipp wrote is truth and something what I also saw using valgrind - memory allocation (overall consumption) of around 300 - 500 kB. To answer at least some one Bob's question from first e-mail, I'm trying to open in memory database (:memory:), so size of

Re: [sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Bob Friesenhahn
On Fri, 13 Jul 2018, Richard Hipp wrote: The OP's test program (with a bug fix, various whitespace changes, and the addition of a call to sqlite3_memory_used()) is show below. sqlite3_memory_used() reports no difference in memory allocation. The usage is uninitialized/unmodified virtual

Re: [sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Richard Hipp
On 7/13/18, Bob Friesenhahn wrote: > On Fri, 13 Jul 2018, Martin Vystrčil wrote: > >> Hello everyone, >> >> I have a problem using sqlite in one of my project. When I create instance >> of sqlite (sqlite_open) from main thread, memory consumption is in normal >> (a few megabytes). But when I

Re: [sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Bob Friesenhahn
On Fri, 13 Jul 2018, Martin Vystrčil wrote: Hello everyone, I have a problem using sqlite in one of my project. When I create instance of sqlite (sqlite_open) from main thread, memory consumption is in normal (a few megabytes). But when I start sqlite from another thread, immediately around 70

[sqlite] Huge RAM usage when sqlite is started from another thread

2018-07-13 Thread Martin Vystrčil
Hello everyone, I have a problem using sqlite in one of my project. When I create instance of sqlite (sqlite_open) from main thread, memory consumption is in normal (a few megabytes). But when I start sqlite from another thread, immediately around 70 - 80 MB of memory is allocated. Here is the