On Wed, 11 Nov 2009, Tim Romano wrote: > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > From: Tim Romano <tim.rom...@yahoo.com> > Subject: [sqlite] etiquette question: PNG attachments (28K, > 11K) of EXPLAIN results permitted? > > 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
I doubt that you are allowed to post attachments here to the list. However you can upload your images here: =============================================== http://www.freeimagehosting.net/ Filename extensions allowed: gif, jpg, bmp, png Filesize limit: 3,000KB Need to upload a file larger than 3MB? Use Free File Hosting =============================================== and then post the URL's to the images here. Kind Regards, Keith Roberts ----------------------------------------------------------------- Websites: http://www.php-debuggers.net http://www.karsites.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] ----------------------------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
