Hans Kristian Rosbach wrote:
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?
No you're right. 'LOAD' is no reservered keyword in SQL99. PostgreSQL
uses 'LOAD <filename>' to load shared libraries.
Is memory usage on insertion a real problem or only a theoretical? If
message size is limited to 25 MB by the MTA and the MTA is only allowed
to deliver 25 messages at once maximum memory usage is 625 MB. But I
think it happens very rarely that 25 mails with the maximum message size
arrive at once and are inserted at once.
Thomas
--
http://www.tmueller.com for pgp key (95702B3B)
