Documentation Source Text

Check-in [26162d3d2b]
Login

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

Overview
Comment:Fix some text in the limits.html page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 26162d3d2b485feae6d7e343b6beed1cede3d16a
User & Date: drh 2014-08-16 18:44:48.230
Context
2014-08-19
10:18
Add a link to the Facebook corruption report caused by using a closed file descriptor. (check-in: a2d97df5b9 user: drh tags: trunk)
2014-08-16
18:44
Fix some text in the limits.html page. (check-in: 26162d3d2b user: drh tags: trunk)
2014-08-15
19:06
Version 3.8.6 (check-in: e477e238b6 user: drh tags: trunk, release, version-3.8.6)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/limits.in.
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
<p>
SQLite does not support joins containing more than 64 tables.
This limit arises from the fact that the SQLite code generator
uses bitmaps with one bit per join-table in the query optimizer.
</p>

<p>
SQLite uses a very efficient O(N&sup2;) greedy algorithm for determining
the order of tables in a join and so a large join can be
[sqlite3_prepare() | prepared] quickly.
Hence, there is no mechanism to raise or lower the limit on the
number of tables in a join.
</p>
}

limititem {Maximum Depth Of An Expression Tree} SQLITE_MAX_EXPR_DEPTH {
<p>







|
<
|







187
188
189
190
191
192
193
194

195
196
197
198
199
200
201
202
<p>
SQLite does not support joins containing more than 64 tables.
This limit arises from the fact that the SQLite code generator
uses bitmaps with one bit per join-table in the query optimizer.
</p>

<p>
SQLite uses a efficient [NGQP| query planner algorithm]

and so even a large join can be [sqlite3_prepare() | prepared] quickly.
Hence, there is no mechanism to raise or lower the limit on the
number of tables in a join.
</p>
}

limititem {Maximum Depth Of An Expression Tree} SQLITE_MAX_EXPR_DEPTH {
<p>