Nicolas there are other people who also receive this mail. if you have code that will help someone else. Please post the information Mr Hipp requested.
Jay On Tue, Apr 28, 2015 at 5:08 PM, Nicolas Boullis <sqlite at ilcode.fr> wrote: > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
