Re: [sqlite] SQLite takes too much memory

On Sat, Jun 28, 2008 at 8:43 AM, Mihai Limbasan <[EMAIL PROTECTED]> wrote: > The posted code does not create 100 prepared statements. It creates just > one, fetches the data, finalizes the statement, then loops. Very true, my mistake. /Jonas ___

Re: [sqlite] SQLite takes too much memory

Jonas Sandman wrote: > You are creating 100 prepared statements, which probably takes a lot of > memory. > What you really want to do is probably create one statement, get all > the data out of it, finalize it and then prepare the next statement > and get THAT data etc. > The posted code does

[sqlite] SQLite takes too much memory

Hi, all I have met a very strange problem: I want to load some binary data from SQLite3 database into a defined structure, so I used the following codes: == Sqlite3_stmt * stat; For (int i = 0; i< 100; i++) { //Step1: sqlite3_prepare_v2(...)