Lines Matching refs:PRAGMA

54   1.1 { PRAGMA mmap_size = 67108864 } /[49]/ {PRAGMA mmap_size = 0}
55   1.2 { PRAGMA mmap_size =    53248 } 150    {PRAGMA mmap_size = 0}
56   1.3 { PRAGMA mmap_size =        0 } 344    {PRAGMA mmap_size = 0}
57   1.4 { PRAGMA mmap_size = 67108864 } /[49]/ {PRAGMA mmap_size = 67108864 }
58   1.5 { PRAGMA mmap_size =    53248 } 150    {PRAGMA mmap_size = 67108864 }
59   1.6 { PRAGMA mmap_size =        0 } 344    {PRAGMA mmap_size = 67108864 }
63     sql1 {PRAGMA cache_size=2000}
64     sql2 {PRAGMA cache_size=2000}
66     sql1 {PRAGMA page_size=1024}
73       PRAGMA page_size=1024;
74       PRAGMA auto_vacuum = 1;
84       sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"
90       sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"
96       sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"
102       sql1 "SELECT count(*) FROM t1; PRAGMA integrity_check ; PRAGMA page_count"
106     # "PRAGMA mmap_size" command worked.
125     PRAGMA auto_vacuum = 1;
126     PRAGMA mmap_size = 67108864;
127     PRAGMA journal_mode = wal;
135     PRAGMA wal_checkpoint;
139     PRAGMA auto_vacuum;
149           PRAGMA wal_checkpoint;
158       PRAGMA wal_checkpoint;
165 execsql { PRAGMA mmap_size = 67108864; }
168   PRAGMA auto_vacuum = 1;
194 execsql { PRAGMA mmap_size = 67108864; }
202   PRAGMA page_size = 1024;
244 execsql { PRAGMA mmap_size = 67108864; }
246   PRAGMA auto_vacuum = 2;
247   PRAGMA page_size = 1024;
254   PRAGMA auto_vacuum;
287     PRAGMA auto_vacuum = 0;
288     PRAGMA page_size = 4096;
299     PRAGMA mmap_size = 1048576;