Hi,
I have a query regarding transactions and tables.
Say in a DB if you have 4 tables, now in my code I will say , "begin
transaction" and start modifying a table, say tbl1, now a journal would be
backed up for the tbl1 that I am going to modify, now if in the same
transaction if I try to modify a different table, say tbl2, in the same DB,
will the multiple inserts into the tbl2 will be fast as we have already a
journal created.
If at this point the power goes off, will tbl2 be consistent?
And one more question,
If in my code if I call "begin transaction" on the same DB twice due to some
logical flow error, will it have any effect.
...
Chetana.
---------------------------------
Get your email and more, right on the new Yahoo.com
