Re: [sqlite] Memory loss with sqlite3_bind - issue resolved

2009-01-12 Thread John Delaney
Hi Jay, Thanks for your response and it is the cache as you say. After ~ 150 inserts memory stabilises thereafter. This equates approx to the 2000 cache pages. Thanks again. John D. > Using SQLite3 3.5.9, I am seeing a consistent rise in memory with each > > call to sqlite3_step(). >>

[sqlite] Memory loss with sqlite3_step()

2009-01-09 Thread John Delaney
Hi, I am a new user so please make allowances accordingly. Using SQLite3 3.5.9, I am seeing a consistent rise in memory with each call to sqlite3_step(). My code pattern to store a 14830 byte buffer is: A. mem = sqlite3_memory_used(); sqlite3_prepare_v2(... B. mem =