2 ms·
The "The Next Generation Query Planner" (NGQP) document https://www.sqlite.org/queryplanner-ng.html https://www.sqlite.org/queryplanner-ng.html linked to from t
by igravious 11y ago
The "The Next Generation Query Planner" (NGQP) document https://www.sqlite.org/queryplanner-ng.html https://www.sqlite.org/queryplanner-ng.html linked to from this document makes for very interesting reading.
In some cases upgrading from the pre-3.8.0 legacy query planner and to the NGQP in 3.8.0 may cause a serious performance regression. Running ANALYSE on your DB should fix that.
Apart from that the Stability Guarantee sounds, I don't know, obvious? Repeatability and predictability under more or less the same conditions should be a given I would have thought. In the DB world this must not necessarily be the case?