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. <[email protected]> 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-only transaction, by which I mean > BEGIN TRANSACTION > SELECT * from SomeTable; > COMMIT > will cause any writes to the WAL? > > What about the -shm file, is it likely that the transaction will cause > a write to the NAND in this case? > > Is there any statistics about actual writes I can query to analyze > write-behavior of my software? > > Thanks in advance! > > Best regards, > Martin > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
