|
|
Posted by NC on 06/12/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
Navigation:
[Reply to this message]
|