Drew Morris <[EMAIL PROTECTED]> said: > We are currently attempting to port dbmail to work on an Microsoft SQL > Server database and we are considering modifying the design slightly > to allow us to store messages in a single TEXT field (which can be up > to 2GB of text in MSSQL). The reason I am writing is to hear whether > we would be able to convince you guys to support a compile-time flag > which would enable this change in the system.
Ilja and Paul were talking about doing this a while ago, because MySQL and PostgreSQL both support very large TEXT fields. I think the main problem is the query size. Right now, we can realistically handle 2 gigabyte messages because we only allocate a few megs at a time as a receive buffer and as that fills, we quote it and send it to the database in a query. To do a single row would involve CONCAT() or some other SQL function (most of which are not ANSI, afaik) and I doubt that it's any more efficient, although I suppose it's worth a test. Aaron
