Debian Codegraph @

www/pgszchng2016.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>Change in Default Page Size in SQLite Version 3.12.0</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118
119
120
121 <h1 align="center">The Default Page Size Change of SQLite 3.12.0</h1>
122
123 <h2>1.0 Introduction</h2>
124
125 <p>
126 An SQLite database file consists of one or more "pages".
127 For a single database file, all pages are the same size, though
128 for different database files, the page size can be any power of
129 two between 512 and 65536, inclusive.
130 </p>
131
132 <p>
133 Since the SQLite database file format was designed (in 2003) the
134 default <a href="pragma.html#pragma_page_size">page size</a> for new databases has been 1024 bytes.
135 This was a reasonable choice in 2003. But on modern hardware,
136 a 4096 byte page is a faster and better choice.
137 So, beginning with SQLite <a href="releaselog/3_12_0.html">version 3.12.0</a> (2016-03-29)) the default
138 page size for new database files has been increased to 4096 bytes.
139 </p>
140
141 <p>
142 The upper bound on the database <a href="pragma.html#pragma_cache_size">cache size</a> has
143 traditionally defaulted to 2000 pages. SQLite <a href="releaselog/3_12_0.html">version 3.12.0</a> also
144 changes this default setting to be "-2000" which means 2000*1024
145 bytes, regardless of page size. So, the upper bound on the amount
146 of memory used for the page cache is unchanged.
147 </p>
148
149 <h2>2.0 <u>Not</u> a Compatibility Break</h2>
150
151 <p>
152 These changes in the default behavior of SQLite are not
153 a compatibility break. All legacy database files continue to be
154 readable and writable by newer versions of SQLite, and all newly
155 created database files continue to be readable and writable by
156 legacy versions of the SQLite library. The only thing that is changing
157 is some default settings. This should result in a performance
158 increase for many applications.
159 </p>
160
161 <p>
162 Though most applications should not notice any change (except that
163 they run a little faster), if problems arise then the
164 legacy behavior can be restored at compile-time by using the
165 following options to the C-compiler:
166
167 <blockquote><pre>
168 -DSQLITE_DEFAULT_PAGE_SIZE=1024
169 -DSQLITE_DEFAULT_CACHE_SIZE=2000
170 </pre></blockquote>
171
172 <p>
173 The page size and cache size can also be set or changed at run-time using the
174 <a href="pragma.html#pragma_page_size">page_size pragma</a> and <a href="pragma.html#pragma_cache_size">cache_size pragma</a>, respectively.
175
176 <h2>3.0 Possible Negative Consequences Of This Change</h2>
177
178 <p>
179 The minimum size of an SQLite database is one page for each table and
180 each index. With a larger page size, the size of an empty database
181 for a given schema will grow by a factor of four, therefore. However,
182 once the database begins to fill with content the size of the older
183 1024-byte page databases and the newer 4096-byte page databases will
184 quickly converge. Due to relaxed bin-packing constraints, the
185 4096-byte page size might actually result in a smaller file, once
186 substantial content is added.
187 </p>
188 <p align="center"><small><i>This page was last updated on 2025-05-31 13:08:22Z </small></i></p>
189