http://bugzilla.spamassassin.org/show_bug.cgi?id=3225
------- Additional Comments From [EMAIL PROTECTED] 2004-04-15 16:17 ------- Michael, I don't want you to forget the other optimizations: 1) Use an INT(11) for username, using the UID instead of a variable character string 2) Express atime as a two byte int with granularity of one day instead of a 4 byte int with granularity of a second. That not only cuts two bytes off of the atime in every record, but it means that the record is updated for the time no more than once a day. 3) The more radical change, use CHAR(5) from SHA1 hash for the tokens. Cutting down the database size by that much has to make a big difference, not to mention the optimization of using all fixed length records and keys. ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee.
