On Freitag 27 Februar 2009 Paul Stevens wrote: > > SELECT ... WHERE hashfield='computed_hash' AND > > headervalue='new_line' and the db can use the index over hashfield > > to find only the 1-2 hashes that fit and finally compare contents > > using the full line. > > good idea. Currently we're doing the value comparison in dbmail, but > leaving it to the database makes perfect sense.
Good, please do that in the messageparts code also, as I guess that will be the same behaviour then. :-) mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
