Re: [sqlite] SQLITE3 Runs out of memory.

2011-11-18 Thread Stuart Thomson
November 2011 13:12 To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLITE3 Runs out of memory. That's obviously not your real code...would be nice to see that as your problem may elsewhere. But... #1 How much memory does your embedded device have AVAILABLE? #2 Try reducing

Re: [sqlite] SQLITE3 Runs out of memory.

2011-11-17 Thread Jean-Christophe Deschamps
Loop for 61153 records start rowIndex at 0 sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB Where id = rowIndex") sqlite3_step() sqlite3_finialize() End Make that sqlite3_prepare_v2 ("SELECT id, blobdata FROM Table30KB") Do sqlite3_step() // handle errors somehow (busy, ...)

Re: [sqlite] SQLITE3 Runs out of memory.

2011-11-17 Thread Black, Michael (IS)
ber 17, 2011 6:51 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] SQLITE3 Runs out of memory. Hi, Before I start diving into the sqlite3 code, I was wondering if anyone had this sort of problem before and could possibly point out to me where I might find the problem. I am running 3.7.9 on a em

[sqlite] SQLITE3 Runs out of memory.

2011-11-17 Thread Stuart Thomson
Hi, Before I start diving into the sqlite3 code, I was wondering if anyone had this sort of problem before and could possibly point out to me where I might find the problem. I am running 3.7.9 on a embedded project using a database with one table (structured (integer id, blobdata BLOB). Now