Re: [sqlite] integrity_check needs too much RAM on WinCE

2007-11-22 Thread Thomas Damme
Dennis Cote schrieb: > Thomas Damme wrote: >> We set "page_size" and "cache_size" both at 8KB because it had the best >> performance on the device. >> > Do you have 64 MB of ram to dedicate to sqlite for its cache? That's > what you are te

Re: [sqlite] integrity_check needs too much RAM on WinCE

2007-11-22 Thread Thomas Damme
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).

[sqlite] integrity_check needs too much RAM on WinCE

2007-11-22 Thread Thomas Damme
vice 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 lo

[sqlite] Changing journal-directory?

2007-10-24 Thread Thomas Damme
k first if there is another way..? Regards, -- Thomas Damme - To unsubscribe, send email to [EMAIL PROTECTED] -