Documentation Source Text

Check-in [b753f5fc5a]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove obsolete text from the limits.html page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b753f5fc5a6c3c0bf394bc66872a17f52df72dcc
User & Date: drh 2008-02-21 20:43:28.000
Context
2008-02-25
13:38
Add Adobe to the homepage. (check-in: 02853d098b user: drh tags: trunk)
2008-02-21
20:43
Remove obsolete text from the limits.html page. (check-in: b753f5fc5a user: drh tags: trunk)
20:01
More fixes to the "most widely deployed SQL database" page. (check-in: 6934667274 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/limits.in.
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
</p>

<p>
The <a href="pragma.html#pragma_max_page_count">
max_page_count PRAGMA</a> can be used to raise or lower this
limit at run-time.
</p>

<p>
Note that the transaction processing in SQLite requires two bits
of heap memory for every page in the database file.  For databases
of a few megabytes in size, this amounts to only a few hundred
bytes of heap memory.  But for gigabyte-sized databases the amount
of heap memory required is getting into the kilobyte range and
for terabyte-sized databases, megabytes of heap memory must be
allocated and zeroed at each transaction.  SQLite will
support very large databases in theory, but the current implementation
is optimized for the common SQLite use cases of embedded devices
and persistent stores for desktop applications.  In other words,
SQLite is designed for use with databases sized in kilobytes or 
megabytes not gigabytes.  If you are building an application to
work with databases that are hundreds of gigabytes or more 
in size, then you should perhaps consider using a different database 
engine that is explicitly designed for such large data sets.
</p>
}
</tcl>







|
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<
<


284
285
286
287
288
289
290
291

















292
293
</p>

<p>
The <a href="pragma.html#pragma_max_page_count">
max_page_count PRAGMA</a> can be used to raise or lower this
limit at run-time.
</p>
</li></ol>

















}
</tcl>