Documentation Source Text: Check-in [26162d3d2b]

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

Overview

Comment:	Fix some text in the limits.html page.
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	26162d3d2b485feae6d7e343b6beed1cede3d16a
User & Date:	drh 2014-08-16 18:44:48

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

Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/limits.in.

<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>








|
<
|

<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>