CODEWITHSUNDEEP
sqlitejoin
New Bentley
New Bentley

Reputation: 465

Is there join number limitation in SQLite?

I'm curious about what's the performance change if adding more joins? is there join number limitation? e.g. if greater than a value, the performance will be degraded. thanks.

Upvotes: 2

Views: 1102

Answers (1)

Stathis Andronikos
Stathis Andronikos

Reputation: 1259

Maximum Number Of Tables In A Join

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.

SQLite uses a very efficient O(N²) greedy algorithm for determining the order of tables in a join and so a large join can be prepared quickly. Hence, there is no mechanism to raise or lower the limit on the number of tables in a join.

see :http://www.sqlite.org/limits.html

Upvotes: 2

Related Questions