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