Posted by NC on 10/16/78 11:38

Eric Anderson wrote:
> NC wrote:
> > This is not necessarily a good thing. Because you want minimize the
> > disk usage, you are missing out on MySQL's ability to process large
> > files very quickly. I would suggest an alternative approach:
> >
> > 1. Copy the remote file to your local disk.
> > 2. Use LOAD DATA INFILE to load the data into MySQL.
> > 3. Delete the data file, if necessary.
>
> Interesting approach. It would be fast and low on resources (although it
> would require usage of the filesystem but perhaps that isn't too big of
> a deal). The only downside is that it is MySQL specific. Currently this
> application is database independent and it would be nice to keep it that
> way.

If memory serves, all SQL databases support import of text files. The
query syntax may differ, but the concept is clearly there...

Cheers,
NC

[Back to original message]