Sounds migratory... But it might be the best approach. I think at the current state of the art the following is reasonably true: SHA1/MD5 is fast enough for the typically allowed file sizes in a mail system (10MB) given the frequency with which they occur.
If someone has a future need of 100MB or 10GB file sizes as the norm then we can also expect to be looking a quad-core also being the norm -- making all things equal. If they have a current need for 100MB files, then they probably already have a really big server at their disposal. One thing I do like about dbmail is the scalability. I interpret this to mean both small and large mail environments can use with application with existing or reasonably hardware. To require super huge machines for a personal domain isn't very scalable. On 6/4/2007, "Paul J Stevens" <[EMAIL PROTECTED]> wrote: > >Tom Allison wrote: >> >> So if I add one line at the end of a word doc, this will be considered >> to be the same file unless the file format includes something unique >> within the first 8MB of the file? > >My point also. Doing sha1 on the whole file seems to make the most sense. >People >who want to do bigger files faster can simply add more lmtpd hosts with bigger >cpus and more ram. > >The proposed schema has some merit, but I would rather setup two new tables >(partslists and mimeparts) which would be functionally like Jonathan's two >tables. Main difference is I want to leave the current tables as they are: new >messages get inserted into the new setup, and old messages are left in the old >format until converted by a lo-pri run of dbmail-util. The message retrieval >code would then first try to reconstruct the message from the new tables and >failing that use the 'old' current setup. > > >-- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl >_______________________________________________ >DBmail mailing list >[email protected] >https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
