News for hackers. Stuff that matters.
Re:Rearchitecting: Redis to SQLite by Groxx on Wednesday September 25, 2024 @11:17PM (#41654200)
Weeellll... I think it's safe to say SQLite's planner is simple, and trends towards "you get what you wrote" rather than having more sophisticated runtime monitoring and adjusting.

But as with all things SQLite, the answer is generally "it's easy to predict so just improve your query" and/or "there's a plugin for that" so it tends to win in the end with a bit of care.

Re:Rearchitecting: Redis to SQLite by thesz on Friday September 27, 2024 @07:14PM (#41676461)
https://www.sqlite.org/queryplanner-ng.html

SQLite's planner is anything but simple. It has a beam search over different plans, basically, it approximates full NP-hard solution search process using bounded space and time.