Re: [sqlite] PRAGMA synchronous = OFF on transaction-safe file system TFAT WinCE

2008-07-06 Thread Karl Tomlinson
Daniel wrote: > Is it safe do set PRAGMA synchronous = OFF when a > transaction-safe file system is used? > > We are working on WinCE with TFAT (see below) - but this might > be a general question. > TFAT: > ... By making file operations > transaction-safe, TFAT stabilizes the file system and

Re: [sqlite] PRAGMA synchronous = OFF on transaction-safe file system TFAT WinCE

2008-07-03 Thread [EMAIL PROTECTED]
Hi! We have a 14MB SQLite database on a 16MB flash disk. The journal file gets to big on some queries, which results in a SQLITE_FULL error. Any other ideas to make data storage secure? Regards Daniel ___ sqlite-users mailing list

[sqlite] PRAGMA synchronous = OFF on transaction-safe file system TFAT WinCE

2008-07-02 Thread [EMAIL PROTECTED]
Hello Is it safe do set PRAGMA synchronous = OFF when a transaction-safe file system is used? We are working on WinCE with TFAT (see below) - but this might be a general question. Regards Daniel TFAT: The original file allocation table (FAT) file system enabled file modification operations