Laura, On Thu, Sep 8, 2016 at 5:22 AM, Laura BERGOENS <laura.bergo...@imerir.com> wrote: > Hi everyone, > > So I've put indexes myself on the most used tables in my program, then > ANALYZE the db, and now it flies. > The automatic creation of index probably took a lot of time, and it affects > even more performance when it's always same queries on same tables that are > repeated over and over again. > > ALl your advice was really precious, thanks a lot
No problem at all! We are here to help, since we were in your boat at least once... ;-) Thank you. > > 2016-09-08 9:44 GMT+02:00 Simon Slavin <slav...@bigfraud.org>: > >> >> On 8 Sep 2016, at 7:27am, Laura BERGOENS <laura.bergo...@imerir.com> >> wrote: >> >> > I took notes of everything you guys said, and I'll spend my morning doing >> > this : >> > >> > Running ANALYZE once per DB I'mUsing, Create indexes myself and contact >> DB >> > Browser to share them the thing. >> >> Do those two steps the other way around. ANALYZE not only analyses your >> tables, it also analyzes your indexes. So you need to make the indexes >> first, then do ANALYZE. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > Laura BERGOENS > Technicienne supérieure en Informatique et étudiante à l'IMERIR de Perpignan > > *Institut Méditerranéen d'Étude etde Recherche en Informatique* > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
