Hi, On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard Hipp wrote: > > Please send us: > > (1) The output of "SELECT sqlite_source_id();" > > (2) The complete text of you SELECT statement. > > (3) The output of the ".fullschema" command from the most recent > version of the sqlite3.exe command-line shell run on your database > file after it is ANALYZE-ed.
Sorry for the very late answer, I?ve been very busy lately. I investigated a little further, measuring the time taken by each SELECT request that was run, and then using EXPLAIN QUERY PLAN to understand why two of them were so slow. Knowing the data, I added a few indices, and now the whole program runs in about 1 second, much better than what I had before. As far as I am concerned, everything is fine, now. Many thanks for your help. Now, if you are realy interested by that surprisingly-good performance I had without indices and without running ANALYZE, I may try to provide you with more details. Thanks to all, -- Nicolas Boullis
