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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d3fe186c330d74209ac291972b09883b |
| User & Date: | drh 2007-06-11 23:23:25 |
Context
|
2007-06-12
| ||
| 18:20 | Minor comment edits from my prefix development client. No code changes. (CVS 4058) (check-in: 6953cd09 user: shess tags: trunk) | |
|
2007-06-11
| ||
| 23:23 | Fix typo in the limits.html document. Ticket #2410. (CVS 4057) (check-in: d3fe186c 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: abf64d1d user: drh tags: trunk) | |
Changes
Changes to www/limits.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
#
# Run this script to generate the limits.html output file
#
set rcsid {$Id: limits.tcl,v 1.1 2007/06/09 09:53:51 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
................................................................................
</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 argument 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.
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
...
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
#
# 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
................................................................................
</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.
|