Have you read this from http://www.sqlite.org/limits.html
*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. Also as a side note I cannot imagine a query that I would need that joins such a large number of tables! HTH Rippo On 22 August 2011 03:47, JoshG <[email protected]> wrote: > Hi There, > > I'm currently using ActiveRecord->NHibernate->SQLite (in memory) > > but I'm receiving an error when executing a query to fetch a > particular record on one of my tables. The error is as follows: > > SQLite error > at most 64 tables in a join > > I'm aware that joining 64 tables isn't necessarily a good thing, > however, I would like to know if there is a way to get NHibernate to > generate appropriate SQL to talk to SQLite and retrieve the required > information. Currently I imagine that this would count as a bug in > NHibernate's SQLite dialect... > > Alternatively, if anyone has any ideas on how I could avoid the 64+ > table join, I'd be interested, though that question should probably be > something for the ActiveRecord forum to address. > > Thanks for your thoughts/help > > Josh > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
