On 6 Dec 2019, at 10:05am, radovan5 <radovan.antl...@siol.net> wrote:
> Just in my case analyze is quite slow also. So in the end I get same time. It > is faster to use just workaround in sql. The results of ANALYZE are stored in the database. So although the total time is about the same when you do run it, once you have run ANALYZE with realistic data, you do not need to run it again. Running the query will be faster every time in the future. Some programmers include ANALYZE in a monthly or yearly maintenance task. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
