*** 6,12 ****
transactions can be more easily read and understood.
----
! {image: commit-0.gif}
*Initial State*
The diagram at the right shows the initial
--- 6,12 ----
transactions can be more easily read and understood.
----
! {rightimage: commit-0.gif}
*Initial State*
The diagram at the right shows the initial
***************
*** 19,25 ****
{clear}
----
! {image: commit-1.gif}
*Step 1*
Before attempting to read the databse, SQLite
--- 19,25 ----
{clear}
----
! {rightimage: commit-1.gif}
*Step 1*
Before attempting to read the databse, SQLite
***************
*** 35,41 ****
{clear}
----
! {image: commit-2.gif}
*Step 2*
Some subset of the database (3 pages in this example)
--- 35,41 ----
{clear}
----
! {rightimage: commit-2.gif}
*Step 2*
Some subset of the database (3 pages in this example)
***************
*** 45,51 ****
{clear}
----
! {image: commit-3.gif}
*Step 3*
The previous steps show what happens when SQLite only
--- 45,51 ----
{clear}
----
! {rightimage: commit-3.gif}
*Step 3*
The previous steps show what happens when SQLite only
***************
*** 70,76 ****
{clear}
----
! {image: commit-4.gif}
*Step 4*
Before any changes are made to the database, the original
--- 70,76 ----
{clear}
----
! {rightimage: commit-4.gif}
*Step 4*
Before any changes are made to the database, the original
***************
*** 87,93 ****
{clear}
----
! {image: commit-5.gif}
*Step 5*
Once the original page content has been written to the
--- 87,93 ----
{clear}
----
! {rightimage: commit-5.gif}
*Step 5*
Once the original page content has been written to the
***************
*** 101,107 ****
{clear}
----
! {image: commit-6.gif}
*Step 6*
Before going further, we have to make sure that the
--- 101,107 ----
{clear}
----
! {rightimage: commit-6.gif}
*Step 6*
Before going further, we have to make sure that the
***************
*** 114,120 ****
{clear}
----
! {image: commit-7.gif}
*Step 7*
We are now ready to write the changes to the database
--- 114,120 ----
{clear}
----
! {rightimage: commit-7.gif}
*Step 7*
We are now ready to write the changes to the database
***************
*** 128,134 ****
{clear}
----
! {image: commit-8.gif}
*Step 8*
Once an exclusive lock is obtained, the modified pages
--- 128,134 ----
{clear}
----
! {rightimage: commit-8.gif}
*Step 8*
Once an exclusive lock is obtained, the modified pages
***************
*** 140,146 ****
{clear}
----
! {image: commit-9.gif}
*Step 9*
The database changes must be flushed to disk. Otherwise
--- 140,146 ----
{clear}
----
! {rightimage: commit-9.gif}
*Step 9*
The database changes must be flushed to disk. Otherwise
***************
*** 151,157 ****
{clear}
----
! {image: commit-A.gif}
*Step 10*
After all database file changes have been written to
--- 151,157 ----
{clear}
----
! {rightimage: commit-A.gif}
*Step 10*
After all database file changes have been written to
***************
*** 166,172 ****
{clear}
----
! {image: commit-B}
*Step 11*
Finally, the locks on the database file are removed, allowing
--- 166,172 ----
{clear}
----
! {rightimage: commit-B}
*Step 11*
Finally, the locks on the database file are removed, allowing
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|