Oh, maybe I should also tell you this: We set "page_size" and "cache_size" both at 8KB because it had the best performance on the device.
Thomas Damme schrieb: > Hello Folks, > > we are running a SQLite-Database(version 3.3.5) on a > WinCE-device(version 4.2). The database is about 90 MB and resides on a > USB-Stick. The database itself contains of about 500 records with BLOBs > from 1KB to 100 KB. > > When we are running an "PRAGMA integrity_check" the device stops and > says "Not enough Program-Memory" in a system-dialogue. So I assume, > SQLite ate up all dynamic RAM for the check and cannot complete. > > Approx. how much RAM is needed for such a check? Can I prevent this? Is > this influenced by the BLOB-size? > > Thanks a lot. -- Thomas Damme ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
