Posted by Eric Anderson on 10/15/92 11:38

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. I'll keep it in mind.

Eric

[Back to original message]