On Fri, 2005-02-11 at 11:21, [EMAIL PROTECTED] wrote: > Aaron Stone wrote: > > On Fri, Feb 11, 2005, Hans Kristian Rosbach <[EMAIL PROTECTED]> said: > >>2. We can use a tempfile > >> Now, this would lead to more database calls depending on block size > >> and it would probably lead to worse performance. > > > [..] > > Take a look at the fifo pipe they use as the 'datafile' about halfway down > > this page: > > http://dev.mysql.com/doc/mysql/en/load-data.html > > > > We could actually use this! As we read from the network, we write to the > > named pipe. It's up to the operating system to do the buffering and > > whatnot, and we're not limited by any size constraints because LOAD DATA > > INFILE implementations are built for big stuff (I think...). > > The requirement for that is that dbmail and the database are on the same > system I think. That's only true for small systems and small systems > never should have problems with too much memory usage.
Yep, so that wouldn't work in our setup atleast. And is it even supported by anything other than mysql? -HK