4 ms·
The write up of the NGQP seems (at least superficially?) weird: they say that the reason for the rewrite was poor performance on a particular artificial benchma
by meshko 13y ago
The write up of the NGQP seems (at least superficially?) weird: they say that the reason for the rewrite was poor performance on a particular artificial benchmark (8-way join.. how often do people join 8 tables in practice?). At the same time, I was surprised to learn that the only kind of join algorithm SQLite supports is nested loops. I would think they would benefit more from adding hash and merge joins instead of rewriting the QP from scratch.
- lsb 13y agoSQLite 3.7.17 already makes automatic indices, if none exists for the join, if the planner recommends it.
- hobs 13y agoI regularly do 20+ table joins.
- recursive 13y ago> how often do people join 8 tables in practice? If I were to judge based on my current experience, I'd say more often than they make queries with less than 8 joins. In the stored procedure I'm working on now, there are many queries with up to 20.