SQLITE Tips - 版本历史

Comcat：/* Drop */

2017-08-25T05:22:50Z

‎Drop

2017-08-25T05:21:33Z

‎Drop

2017-08-25T05:21:00Z

‎Drop

2017-08-25T05:20:34Z

‎Index

2017-08-25T05:18:40Z

‎Clean up DB file size

2017-08-25T04:51:09Z

‎Clean up DB file size

2017-08-25T04:50:58Z

‎Clean up DB file size

2017-08-25T04:50:31Z

‎Dump table

2017-08-25T04:40:15Z

‎Dump database

2017-08-25T03:21:09Z

‎Execute cmd.sql

@@ 第158行： / 第158行： @@
 <source lang=bash>
-sqlite> drop index if exist idx_id;
+sqlite> drop index if exists idx_id;
 sqlite> drop index idx_type;
 sqlite> explain query plan select * from t_meter_info where f_meter_proto_type='0';

@@ 第160行： / 第160行： @@
 sqlite> drop index if exist idx_id;
 sqlite> drop index idx_type;
-sqlite> explain query plan select * from t_meter_info where f_meter_proto_type=4;
+sqlite> explain query plan select * from t_meter_info where f_meter_proto_type='0';
 selectid|order|from|detail
 |0|0|SCAN TABLE t_meter_info

@@ 第160行： / 第160行： @@
 sqlite> drop index if exist idx_id;
 sqlite> drop index idx_type;
 </source>

@@ 第129行： / 第129行： @@
 == Index ==
 <source lang=bash>
@@ 第151行： / 第153行： @@
 </source>
 <br><br>

@@ 第125行： / 第125行： @@
 Reference: http://www.sqlite.org/pragma.html#pragma_auto_vacuum
 <br><br>
 <br><br>
 <br><br>
 <br><br>

@@ 第118行： / 第118行： @@
 next time new information is added to the database. But in the meantime, the database file might be larger than strictly necessary. Also,
 frequent inserts, updates, and deletes can cause the information in the database to become fragmented - scrattered out all across the database
- file rather than clustered together in one place.
+file rather than clustered together in one place.
 The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file

@@ 第115行： / 第115行： @@
 <pre>
-When an object (table, index, trigger, or view) is dropped from the database, it leaves behind empty space. This empty space will be reused the next time new information is added to the database. But in the meantime, the database file might be larger than strictly necessary. Also, frequent inserts, updates, and deletes can cause the information in the database to become fragmented - scrattered out all across the database file rather than clustered together in one place.
+When an object (table, index, trigger, or view) is dropped from the database, it leaves behind empty space. This empty space will be reused the
-The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure.
+The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file
 </pre>

@@ 第76行： / 第76行： @@
 sqlite> .dump
 sqlite> .exit
 </source>