Re: [sqlite] Runtime memory growth concerns

Discussion of SQLite Database' Subject: Re: [sqlite] Runtime memory growth concerns Hi there, I am playing with the PRAGMA cache_size and it seems to help lots. I will keep you posted ;-) Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...

Re: [sqlite] Runtime memory growth concerns

@sqlite.org Subject: Re: [sqlite] Runtime memory growth concerns Interesting, seems that for my queue implementation using SQLite in WAL mode if I keep a "global" connection handle open while the client is using the queue then the memory grows quickly..but if I open and close the handle on

Re: [sqlite] Runtime memory growth concerns

Interesting, seems that for my queue implementation using SQLite in WAL mode if I keep a "global" connection handle open while the client is using the queue then the memory grows quickly..but if I open and close the handle on each SEND, RECEIVE etc then all is fine... Does this sound right?

Re: [sqlite] Runtime memory growth concerns

Hi there, Regarding the message I sent earlier...Just a quick update from my side, it seems when I run the following sqlite3_step(stmt); The memory grows and does not get released in my specific case even though I set sqlite3_finalize(stmt); after it. The moment I comment

[sqlite] Runtime memory growth concerns

Hi there, I am a huge SQLite fan and am very curious as to why the following would happen. Essentially I have a "queue implementation" using SQLIte in WAL mode and it is working really well. However, at runtime if I watch the Task Manager in windows as thousands of messages are sent to