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] 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to