Re: [sqlite] Query maximum JOIN

2004-08-14 Thread Lorenzo Campedelli
Hi, I encountered such problem a while ago. So I will try to tell you what I know about it. There should not be an explicit limit in the number of joins SQLite can perform, actually it seems that the first 32 tables could use an index, while for the following ones indexes should be ignored, but th

[sqlite] Query maximum JOIN

2004-08-11 Thread Simon Berthiaume
Hi, I would like to know if there is any maximum to the number of JOIN (LEFT JOIN actualy) I can put in a query. I tried to make a query with 31-32 JOIN and the engine returned no row, but returned no error message either so I don't know. Just a single JOIN before, the query was still returning dat