I am trying to import a tab delimited text file of size 21
gb with an estimated 63million records. I do not have a
multi-processor machine. Only 4 or five 2.0 GHz Pentium
IV that can network. Two machines have about 30 Gbs to
spare and the other two or three could probably spare 10-
12 gbs. The all have 256 mb ram. I was hoping to divide
the database into tables of about 200,000 records each so
that I can see load the whole table onto the ram, although
I am not sure that makes any sense. As you can see, I am
not a professional.
So my first question is that will I be able to run
select queries that will search all the seperate tables on
these 4-5 PCs and give me combined results?
My second question concerns a Hash error that comes up
if I try to import records beyond record number 1245456.
What is an hash error and what can I do about it? Someone
mentioned correcting the hash character in the text file,
but I can not open that file, it is to big to open in
notepad or word.
Imran J. Khan