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.
Thomas
--
http://www.tmueller.com for pgp key (95702B3B)
