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