On 30 Jan 2016, at 6:56pm, Yannick Duch?ne <yannick_duchene at yahoo.fr> wrote: > > That's strange, or may be it's SQLiteBrowser specific (I'm using it to test > queries and get timings).
Oh, you're not using your own code. Download the SQLite command line tool and try the same queries. The shell tool does no caching or optimisation of its own, it just calls the SQLite API directly. https://www.sqlite.org/download.html https://www.sqlite.org/cli.html Simon.
