Fossil SCM
Make the default page size on SQL archives 512 bytes.
Commit
f5c81a6c4f36c51da6b715691a90d39ac6b4da1884bf1b6b86841271a4b2face
Parent
768e19219f86937…
1 file changed
+1
+1
| --- src/zip.c | ||
| +++ src/zip.c | ||
| @@ -406,10 +406,11 @@ | ||
| 406 | 406 | SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE, p->vfs.zName |
| 407 | 407 | ); |
| 408 | 408 | assert( p->db ); |
| 409 | 409 | blob_zero(&p->tmp); |
| 410 | 410 | sqlite3_exec(p->db, |
| 411 | + "PRAGMA page_size=512;" | |
| 411 | 412 | "PRAGMA journal_mode = off;" |
| 412 | 413 | "PRAGMA cache_spill = off;" |
| 413 | 414 | "BEGIN;" |
| 414 | 415 | "CREATE TABLE sqlar(" |
| 415 | 416 | "name TEXT PRIMARY KEY, -- name of the file\n" |
| 416 | 417 |
| --- src/zip.c | |
| +++ src/zip.c | |
| @@ -406,10 +406,11 @@ | |
| 406 | SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE, p->vfs.zName |
| 407 | ); |
| 408 | assert( p->db ); |
| 409 | blob_zero(&p->tmp); |
| 410 | sqlite3_exec(p->db, |
| 411 | "PRAGMA journal_mode = off;" |
| 412 | "PRAGMA cache_spill = off;" |
| 413 | "BEGIN;" |
| 414 | "CREATE TABLE sqlar(" |
| 415 | "name TEXT PRIMARY KEY, -- name of the file\n" |
| 416 |
| --- src/zip.c | |
| +++ src/zip.c | |
| @@ -406,10 +406,11 @@ | |
| 406 | SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE, p->vfs.zName |
| 407 | ); |
| 408 | assert( p->db ); |
| 409 | blob_zero(&p->tmp); |
| 410 | sqlite3_exec(p->db, |
| 411 | "PRAGMA page_size=512;" |
| 412 | "PRAGMA journal_mode = off;" |
| 413 | "PRAGMA cache_spill = off;" |
| 414 | "BEGIN;" |
| 415 | "CREATE TABLE sqlar(" |
| 416 | "name TEXT PRIMARY KEY, -- name of the file\n" |
| 417 |