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

Reply via email to