. I have
since changed to using load data infile and performance is greatly
improved on my regular imports but I still have problems when I get to high
record counts. I am looking for a book that covers the various server
settings and what not.
-
Larry Hotchkiss
big input file or perhaps
just validate the contents of the uploaded files and then do a load data
infile for each of them?
Anyways, my goal is to get around the apparent insert limitations I am
running up against.
-
Larry Hotchkiss
get thie error even though check table reports no problems? And
why does my script abort with a corrupt table when I break 1 million
records?
P.S. I am no where close to OS file limitations, at 1.1 million records, my
table is about 60 meg.
-
Larry Hotchkiss
Im just using a default RH 7.1 install of mysql 3.23.36, no tweaks as of
yet. PII 300 has 128 meg of RAM. My current opened_tables is 69 and my
key_reads is 210251. My current db consists of 4 small tables.
-
Larry Hotchkiss