On 10/1/19, Fredrik Larsen <frel...@gmail.com> wrote: > > The declarative model of SQL is nice, but when you care about performance, > it quickly gets frustrating and time consuming.
In a perfect world, the query planner would recognize your intent and do the right thing. You would be able to write the query any way you want, and the result would always be fast. Alas, SQLite's query planner is not perfect. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users