Re: [sqlite] Will a read-only transaction cause writes to the WAL?

Hi, thanks for the clarification. I may need to add a custom implementation of the VFS or a patch for the -shm files to be held on memory-disk then. Regarding the question, why I want to wrap reads in a transaction is, because I don't know if there'll be a write as part of the transaction in befo

Re: [sqlite] Will a read-only transaction cause writes to the WAL?

Reads to not write to the WAL. But they might write to the shared-memory. On Thu, Sep 16, 2010 at 1:16 PM, Martin C. wrote: > Hi, > > I am using SQLite on a NAND based embedded system, and to ensure the > lifetime of the NAND I need to optimize writes to the NAND. > > Can you tell me, if a read

Re: [sqlite] Will a read-only transaction cause writes to the WAL?

Just curious why you wrap your SELECT statement into a 'TRANSACTION' ... -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Martin C. Sent: quinta-feira, 16 de setembro de 2010 14:16 To: sqlite-users@sqlite.org Subject: [sqlite]