Sqlite - Study Notes 3

Analyze and Optimize

sqlite_stat1 is an internal table. It is not in the output of .tables.

 

Suggested Pragmas

 

Faster inserts

Method 1 (a bit risky): 

Method 2: