My update query has been running for 45 minutes, and I'm not sure how to stop it. I think it's selecting a row from a table with 25,000 rows 4 million times rather than selecting a row from a table with 4 million rows 25,000 times.
To prevent this in the future, I need to learn more about how to interpret the results of EXPLAIN. Is it permissible to attach two small screen-captures of the EXPLAIN command output? 28K and 11K. Or are attachments forbidden? I don't know how to capture the results as plain text. Thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users