On 19 Apr 2017, at 7:50pm, Gabriele Lanaro <gabriele.lan...@gmail.com> wrote:
> *SELECT* count(datatable.id) *FROM* fts5_table, datatable *WHERE* > fts5_table *MATCH* ‘term’ *AND* datatable.id = fts5_column.rowid If datatable.id is never NULL, then "count(*)" should do the same thing and be faster. > 1) ANALYZE > > Decreased the speed by orders of magnitude. That’s never supposed to happen. Just to make sure I understand this … Are you saying that you have a situation where ANALYZE made something slower ? If so, have you kept a copy of the database before you executed ANALYZE ? There are some commands which will reveal what happened. Given the efforts you’ve been to with other commands, you might want to try VACUUM. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users