* Cindy > OK, I determined that at least part of the problem was that I ran out > of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in > size an am trying again. But I'd still be very interested in any > comments on the below select statement given the size of everything > involved (eg, an 1800M file output, 79,603,007 entries to be exact). I > would have thought it would be best to have mysql do the sorting > before writing out the file, instead of letting it write it out > unsorted and using an external sort to sort later? Yes? No? Any > comments at all? Hello? > > > Cindy writes: > > > >I wrote earlier: > > > > >select b.id, a.aid, a.wid, a.start, a.length > > > into outfile 'newindex.txt' > > > from wordindex a, wordforms b > > > where a.wordform = b.wordform > > > order by b.id, a.id, a.wid, a.start;
Could you provide some more info? The output of "DESCRIBE select b.id, a.aid..." would be very usefull, and also the output of "SHOW CREATE TABLE wordindex" and "SHOW CREATE TABLE wordforms". -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
