1 #!/bin/bash
   2 
   3 db_file=$1
   4 
   5 
   6 cat << EOF | sqlite3 $db_file
   7 PRAGMA synchronous = OFF;
   8 PRAGMA cache_size = 800000;
   9 PRAGMA journal_mode = OFF;
  10 PRAGMA count_changes = OFF;
  11 PRAGMA temp_store = MEMORY;
  12 PRAGMA locking = EXCLUSIVE;
  13 
  14 CREATE INDEX type_size_idx on type_size (type);
  15 CREATE INDEX type_val_idx on type_value (type);
  16 
  17 EOF
  18 
  19