On Mon, 2007-06-04 at 09:25 +0200, Paul J Stevens 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.
This is pretty much what I'm thinking, too. I'm not sure if a new mimeparts table is even needed; I think that the messageblks table would be the same, but would have one new level of indirection through the mimeparts relation table. If a message did not have any entries in the mimeparts table, that means the messageblks have to be assembled in memory first in order to get at the mimeparts. Aaron _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
