Just curious why you wrap your SELECT statement into a 'TRANSACTION' ... -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Martin C. Sent: quinta-feira, 16 de setembro de 2010 14:16 To: [email protected] Subject: [sqlite] Will a read-only transaction cause writes to the WAL?
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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
