On Sat, 30 Jan 2016 17:41:49 +0000 Simon Slavin <slavins at bigfraud.org> wrote:
> > On 30 Jan 2016, at 4:55pm, Yannick Duch?ne <yannick_duchene at yahoo.fr> > wrote: > > > Tweaking a query, I notice a query executed after I did an `explain query > > plan <query>`, executes faster than before it occured. > > Computer reads data from disk when you do the "EXPLAIN QUERY PLAN". Data > still in cache when you run the real SELECT. > > To see something similar run the same SELECT twice. I forget to tell: I though about it, and tried this. Running the query multiple times, does not change the timing that much (just minus 15 to 20ms). > > I could go from 300ms to 200ms (still too much to me) using an appropriate > > index > > You may be able to improve it further using a better index, better COLLATEs, > or a better schema. We're happy to help you. I don't want to abuse :-P . Half?joking, if I'm stuck, I may. -- Yannick Duch?ne