Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix typo in the limits.html document. Ticket #2410. (CVS 4057) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
d3fe186c330d74209ac291972b09883b |
User & Date: | drh 2007-06-11 23:23:25.000 |
Context
2007-06-12
| ||
18:20 | Minor comment edits from my prefix development client. No code changes. (CVS 4058) (check-in: 6953cd0935 user: shess tags: trunk) | |
2007-06-11
| ||
23:23 | Fix typo in the limits.html document. Ticket #2410. (CVS 4057) (check-in: d3fe186c33 user: drh tags: trunk) | |
12:56 | Fix a bug in the LIKE optimization that was causing the pattern string to be dequoted twice. Ticket #2407. (CVS 4056) (check-in: abf64d1d0a user: drh tags: trunk) | |
Changes
Changes to www/limits.tcl.
1 2 3 | # # Run this script to generate the limits.html output file # | | | 1 2 3 4 5 6 7 8 9 10 11 | # # Run this script to generate the limits.html output file # set rcsid {$Id: limits.tcl,v 1.2 2007/06/11 23:23:25 drh Exp $} source common.tcl header {Implementation Limits For SQLite} puts { <h2>Limits In SQLite</h2> <p> "Limits" in the context of this article means sizes or |
︙ | ︙ | |||
101 102 103 104 105 106 107 | </ul> <p> The default setting for SQLITE_MAX_COLUMN is 2000. You can change it at compile time to values as large as 32676. You might be able to redefine this value to be as large as billions, though nobody has ever tried doing that so we do not know if it will work. On the other hand, there | | | 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 | </ul> <p> The default setting for SQLITE_MAX_COLUMN is 2000. You can change it at compile time to values as large as 32676. You might be able to redefine this value to be as large as billions, though nobody has ever tried doing that so we do not know if it will work. On the other hand, there are people who will argue that a well-normalized database design will never need a value larger than about 100. </p> <p> In most applications, the number of columns is small - a few dozen. There are places in the SQLite code generator that use algorithms that are O(N²) where N is the number of columns. |
︙ | ︙ |