Re: Repeat loops in mysql, large data issue, suggestions wanted

[beacker]

Scott Haneda writes:
>My trouble is that the data file could be 100,000 lines in length, I have a
>few options:

Scott,
     I have a 30 million record dataset that I load into MySQL every couple
of months.  To do this propitiously I use the 'LOAD DATA INFILE' syntax.
From your description it should be quite possible for you to utilize this
same loading mechanism.
                Brad Eacker (beacker@stripped)