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 reducin

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, ...) Un

Re: [sqlite] SQLITE3 Runs out of memory.

2011-11-17 Thread Black, Michael (IS)
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 the cache_size (if #1 is less than 10's of megabytes) -- default cache_size is 1MB which is right around 33*30