Lines Matching refs:PRAGMA

13 # "PRAGMA journal_mode=WAL" mode.
26 #   PRAGMA journal_mode = WAL;
37   db eval { PRAGMA main.journal_mode = WAL }
43   # "PRAGMA journal_mode = WAL" and a new connection use the same
46   # If "PRAGMA journal_mode" is executed immediately, connection [db] (the 
54     set jm  [db one  {SELECT * FROM sqlite_master ; PRAGMA main.journal_mode}]
56     set jm2 [db2 one {SELECT * FROM sqlite_master ; PRAGMA main.journal_mode}]
71     PRAGMA journal_mode = WAL;
76     PRAGMA wal_checkpoint;
106     PRAGMA auto_vacuum = 1;
107     PRAGMA journal_mode = WAL;
119     PRAGMA wal_checkpoint;
135       PRAGMA auto_vacuum = 0;
136       PRAGMA journal_mode = WAL;
139       PRAGMA wal_checkpoint;
155     PRAGMA page_size = 512;
156     PRAGMA journal_mode = WAL;
162   execsql { PRAGMA wal_autocheckpoint = 0 }
196     PRAGMA page_size = 512;
197     PRAGMA journal_mode = WAL;
198     PRAGMA wal_autocheckpoint = 0;
237     PRAGMA page_size = 512;
238     PRAGMA journal_mode = WAL;
239     PRAGMA wal_autocheckpoint = 0;
264     PRAGMA journal_mode = WAL;
272   execsql { PRAGMA cache_size = 10 }
299     PRAGMA journal_mode = WAL;
310   execsql { PRAGMA cache_size = 10 }
336     PRAGMA journal_mode = WAL;
337     PRAGMA wal_autocheckpoint = 0;
353     PRAGMA cache_size = 10;
386     PRAGMA journal_mode = WAL;
387     PRAGMA wal_autocheckpoint = 0;
414   db2 eval { PRAGMA wal_checkpoint }
428     PRAGMA journal_mode = WAL;
429     PRAGMA wal_autocheckpoint = 0;
460     PRAGMA journal_mode = WAL;
461     PRAGMA wal_autocheckpoint = 0;
475   db eval { PRAGMA locking_mode = exclusive }
485   db eval { PRAGMA locking_mode = exclusive }
487   db eval { PRAGMA journal_mode = delete }
510     PRAGMA locking_mode = exclusive;
511     PRAGMA journal_mode = WAL;
528     PRAGMA auto_vacuum = 0;
529     PRAGMA journal_mode = WAL;
542     PRAGMA wal_checkpoint = full;
558     PRAGMA auto_vacuum = 0;
559     PRAGMA journal_mode = WAL;
572     PRAGMA locking_mode = exclusive;
579     PRAGMA locking_mode = normal;