ANALYZE dosn't help because data is loaded from RDBMS
for processing every time.
Why this change give different times (nobody is interested):
"and R.ID_ARHDAJ is not null"
to
"and ifnull(R.ID_ARHDAJ,0) <> 0"
Regards Radovan
On 06.12.2019 15:52, Simon Slavin wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users