diff -r 80ef3a206772 -r 48780e181b38 Symbian3/SDK/Source/GUID-0D093559-793F-5CDC-BB66-8FE1C8A3850E.dita --- a/Symbian3/SDK/Source/GUID-0D093559-793F-5CDC-BB66-8FE1C8A3850E.dita Fri Jul 16 17:23:46 2010 +0100 +++ b/Symbian3/SDK/Source/GUID-0D093559-793F-5CDC-BB66-8FE1C8A3850E.dita Tue Jul 20 12:00:49 2010 +0100 @@ -19,13 +19,13 @@ other techniques.
Transient tables
Transient tables are created by the database engine to compute intermediate results.
Transient tables are stored on disk by default, which may result in unexpected I/O calls -that will probably have a negative impact on database performance.
Prevent datafile corruption
Datafile +that will probably have a negative impact on database performance.
Prevent datafile corruption
Datafile corruption is corruption of the file containing a database with invalid data.
Datafile corruption can occur after a system crash or loss of power. SQLite maintains files called rollback journals from which the last valid state of a database can be reconstructed. However, if a rollback journal is removed or renamed during recovery from a crash, for instance in the course of application recovery -the database will remain corrupted.
SQL index tips
Indexes +the database will remain corrupted.
SQL index tips
Indexes are added either manually or automatically to columns of a data table to speed up SELECT operations.
Indexes greatly speed up the performance of SELECT statements but can impact on insertions, updates and deletions and