On 13 Oct 2006 13:01:28 -0000, you wrote: >Hi, > I wanted to know how does a transaction work.. > >In the following example shown below, where is the transaction updated. Is it >in the memory or some temp file or is it directly written to the database >file. Please give more internal details on this. > >sqlite_exec_printf(pDBHandle,"begin transaction;", 0, 0, NULL); > >sqlite_exec_printf(pDBHandle, "update table1 set c1 = 1",0,0,0,NULL); >sqlite_exec_printf(pDBHandle, "update table2 set c1 = 1",0,0,0,NULL); >sqlite_exec_printf(pDBHandle, "update table3 set c1 = 1",0,0,0,NULL); >sqlite_exec_printf(pDBHandle, "update table4 set c1 = 1",0,0,0,NULL); > >sqlite_exec_printf(pDBHandle,"COMMIT;", 0, 0, NULL);
These pages might give you the insight you need: http://www.sqlite.org/arch.html (Page Cache) http://www.sqlite.org/opcode.html (Transaction) http://www.sqlite.org/lockingv3.html (Rollback Journal) There are many more docs available in: http://www.sqlite.org/docs.html Enjoy! -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
