Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Changes In Branch preload-pragma Excluding Merge-Ins
This is equivalent to a diff from 32c0325bcb to 6dca23e64e
2015-02-03
| ||
19:20 | Fix a typo in the --help output for speedtest1. Fix a dependency error in the Makefile.in for speedtest1. (check-in: f30a057aee user: drh tags: trunk) | |
2015-02-02
| ||
22:19 | Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. (Leaf check-in: 6dca23e64e user: drh tags: preload-pragma) | |
21:34 | Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. (check-in: 32c0325bcb user: drh tags: trunk) | |
2015-01-30
| ||
20:59 | Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased. (check-in: 42d5601739 user: drh tags: trunk) | |
Changes to src/pragma.c.
︙ | |||
1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 | 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 | + + + + + + + + + + + + + + + + + + + + + + | */ case PragTyp_CASE_SENSITIVE_LIKE: { if( zRight ){ sqlite3RegisterLikeFunctions(db, sqlite3GetBoolean(zRight, 0)); } } break; /* Try to load the entire database file into the pcache. */ case PragTyp_PRELOAD: { Pager *pPager = sqlite3BtreePager(pDb->pBt); Pgno i, nPage; int rc = SQLITE_OK; DbPage *pPage, *pPage0 = 0; if( pPager && sqlite3PagerSharedLock(pPager)==SQLITE_OK && sqlite3PagerGet(pPager, 1, &pPage0)==SQLITE_OK ){ sqlite3PagerPagecount(pPager, (int*)&nPage); for(i=2; rc==SQLITE_OK && i<=nPage; i++){ rc = sqlite3PagerGet(pPager, i, &pPage); sqlite3PagerUnref(pPage); } if( rc ) sqlite3ErrorMsg(pParse, "preload failed"); } sqlite3PagerUnref(pPage0); break; } #ifndef SQLITE_INTEGRITY_CHECK_ERROR_MAX # define SQLITE_INTEGRITY_CHECK_ERROR_MAX 100 #endif #ifndef SQLITE_OMIT_INTEGRITY_CHECK /* Pragma "quick_check" is reduced version of |
︙ |
Changes to src/pragma.h.
︙ | |||
24 25 26 27 28 29 30 | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | + - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + | #define PragTyp_JOURNAL_MODE 18 #define PragTyp_JOURNAL_SIZE_LIMIT 19 #define PragTyp_LOCK_PROXY_FILE 20 #define PragTyp_LOCKING_MODE 21 #define PragTyp_PAGE_COUNT 22 #define PragTyp_MMAP_SIZE 23 #define PragTyp_PAGE_SIZE 24 #define PragTyp_PRELOAD 25 |
︙ | |||
301 302 303 304 305 306 307 308 309 310 311 312 313 314 | 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 | + + + + | #endif #if defined(SQLITE_DEBUG) { /* zName: */ "parser_trace", /* ePragTyp: */ PragTyp_PARSER_TRACE, /* ePragFlag: */ 0, /* iArg: */ 0 }, #endif { /* zName: */ "preload", /* ePragTyp: */ PragTyp_PRELOAD, /* ePragFlag: */ 0, /* iArg: */ 0 }, #if !defined(SQLITE_OMIT_FLAG_PRAGMAS) { /* zName: */ "query_only", /* ePragTyp: */ PragTyp_FLAG, /* ePragFlag: */ 0, /* iArg: */ SQLITE_QueryOnly }, #endif #if !defined(SQLITE_OMIT_INTEGRITY_CHECK) |
︙ | |||
448 449 450 451 452 453 454 | 453 454 455 456 457 458 459 460 | - + | #if !defined(SQLITE_OMIT_FLAG_PRAGMAS) { /* zName: */ "writable_schema", /* ePragTyp: */ PragTyp_FLAG, /* ePragFlag: */ 0, /* iArg: */ SQLITE_WriteSchema|SQLITE_RecoveryMode }, #endif }; |
Changes to tool/mkpragmatab.tcl.
︙ | |||
303 304 305 306 307 308 309 310 311 312 313 314 315 316 | 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 | + + | NAME: activate_extensions IF: defined(SQLITE_HAS_CODEC) || defined(SQLITE_ENABLE_CEROD) NAME: soft_heap_limit NAME: threads NAME: preload } # Open the output file # set destfile "[file dir [file dir [file normal $argv0]]]/src/pragma.h" puts "Overwriting $destfile with new pragma table..." set fd [open $destfile wb] |
︙ |