Index: src/pragma.c
==================================================================
--- src/pragma.c
+++ src/pragma.c
@@ -1340,10 +1340,32 @@
     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
 

Index: src/pragma.h
==================================================================
--- src/pragma.h
+++ src/pragma.h
@@ -26,27 +26,28 @@
 #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_SECURE_DELETE                 25
-#define PragTyp_SHRINK_MEMORY                 26
-#define PragTyp_SOFT_HEAP_LIMIT               27
-#define PragTyp_STATS                         28
-#define PragTyp_SYNCHRONOUS                   29
-#define PragTyp_TABLE_INFO                    30
-#define PragTyp_TEMP_STORE                    31
-#define PragTyp_TEMP_STORE_DIRECTORY          32
-#define PragTyp_THREADS                       33
-#define PragTyp_WAL_AUTOCHECKPOINT            34
-#define PragTyp_WAL_CHECKPOINT                35
-#define PragTyp_ACTIVATE_EXTENSIONS           36
-#define PragTyp_HEXKEY                        37
-#define PragTyp_KEY                           38
-#define PragTyp_REKEY                         39
-#define PragTyp_LOCK_STATUS                   40
-#define PragTyp_PARSER_TRACE                  41
+#define PragTyp_PRELOAD                       25
+#define PragTyp_SECURE_DELETE                 26
+#define PragTyp_SHRINK_MEMORY                 27
+#define PragTyp_SOFT_HEAP_LIMIT               28
+#define PragTyp_STATS                         29
+#define PragTyp_SYNCHRONOUS                   30
+#define PragTyp_TABLE_INFO                    31
+#define PragTyp_TEMP_STORE                    32
+#define PragTyp_TEMP_STORE_DIRECTORY          33
+#define PragTyp_THREADS                       34
+#define PragTyp_WAL_AUTOCHECKPOINT            35
+#define PragTyp_WAL_CHECKPOINT                36
+#define PragTyp_ACTIVATE_EXTENSIONS           37
+#define PragTyp_HEXKEY                        38
+#define PragTyp_KEY                           39
+#define PragTyp_REKEY                         40
+#define PragTyp_LOCK_STATUS                   41
+#define PragTyp_PARSER_TRACE                  42
 #define PragFlag_NeedSchema           0x01
 #define PragFlag_ReadOnly             0x02
 static const struct sPragmaNames {
   const char *const zName;  /* Name of pragma */
   u8 ePragTyp;              /* PragTyp_XXX value */
@@ -303,10 +304,14 @@
   { /* 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 },
@@ -450,6 +455,6 @@
     /* ePragTyp:  */ PragTyp_FLAG,
     /* ePragFlag: */ 0,
     /* iArg:      */ SQLITE_WriteSchema|SQLITE_RecoveryMode },
 #endif
 };
-/* Number of pragmas: 58 on by default, 71 total. */
+/* Number of pragmas: 59 on by default, 72 total. */

Index: tool/mkpragmatab.tcl
==================================================================
--- tool/mkpragmatab.tcl
+++ tool/mkpragmatab.tcl
@@ -305,10 +305,12 @@
   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"