On 19 Nov 2017, at 6:15am, Howard Kapustein <[email protected]> wrote:
> On 10 Nov 2017, at 8:49am, advancenOO <[email protected]> wrote: > >> hAve you optimised your column orders ? > What is optimal? SQLite reads only up to the last column it needs to execute the command. So you put your most frequently used columns at the beginning of the table definition. Have you created indexes ideally suited to your WHERE and ORDER BY clauses ? We see a lot of people here asking about obscure complicated features of how SQLite works who haven’t done basic optimization things that apply to all SQL engines. That’s what’s behind the questions advancenOO and I asked. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
