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
