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
* 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
OK I must say I don't think much of this filter if it couldn't tell
it was a relevant question. After all, there's a select statement in
it!! Anyway, any help or comments appreciated. Since initially
sending this, I've learned why my predecesser did it this way -- eight
hours later, and it's
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;
I've actually sat down and tried this at the mysql command line.