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. (I tend to call the 3rd party tool SQLiteBrowser since it's the name of the package when you install it through apt-get) I'll come back to you guys with the results of this asap. Thanks again for sharing your time 2016-09-08 2:09 GMT+02:00 Bob McFarlane <b...@tmgca.com>: > Please reply if you sent this. Thanks. > > > > > > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On > Behalf Of Chris Locke > Sent: Wednesday, September 7, 2016 12:12 PM > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] Query time execution difference between my > application > and SQLiteBrowser > > >First of all, I'll check all the pragmas and stuff, plus the version of > >SQliteBrowser (former DB Browser for SQlite indeed) I'm using, etc. > > Just to confirm (as it seems to be overlooked) that SQLite Browser > (actually > now called DB Browser for SQLite, rather than formerly...) is a 3rd party > tool. > I can post your query to their issues board though ... its still in high > development, and its curious the version number irregularities... > https://github.com/sqlitebrowser/sqlitebrowser/issues > > > Thanks, > Chris > > > On Wed, Sep 7, 2016 at 4:04 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > > > On 7 Sep 2016, at 3:48pm, Laura BERGOENS <laura.bergo...@imerir.com> > > wrote: > > > > > This query takes 100 seconds approx. > > > > Once your tables have some convincing data in (does not need to be > > final data, just something useful to see how the values are > > distributed), run "ANALYZE", just once. It might speed up later > > SELECTs. It might not. But a situation where you have many 'AND' > > clauses looking at different columns is exactly what ANALYZE is most > helpful for. > > > > And yes, a 50 kilorow table is not big by SQLite standards. I have > > tables with a thousand times that that yield answers to SELECT in 5ms. > > > > Simon. > > _______________________________________________ > > 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 > > > > TMGID:S11411219126200001015 > _______________________________________________ > 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
