1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 |
- PRAGMA page_size=8192;
- PRAGMA journal_mode=PERSIST;
- PRAGMA mmap_size=0;
- PRAGMA journal_mode=TRUNCATE;
- PRAGMA mmap_size=28672;
- PRAGMA journal_mode=MEMORY;
- PRAGMA journal_mode=OFF;
- PRAGMA mmap_size(268435456);
- PRAGMA page_size=16384;
- VACUUM;
- CREATE TABLE pgsz(taskid, sz INTEGER);
- INSERT INTO pgsz VALUES(1, eval('PRAGMA page_size'));
- INSERT INTO pgsz VALUES(2, eval('PRAGMA page_size'));
- INSERT INTO pgsz VALUES(3, eval('PRAGMA page_size'));
- INSERT INTO pgsz VALUES(4, eval('PRAGMA page_size'));
- INSERT INTO pgsz VALUES(5, eval('PRAGMA page_size'));
- SELECT sz FROM pgsz;
|