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 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
