-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Henrik K wrote: >>> So token was both a primary key, and an index, which is redundant. >> How is that redundant? If you search for only a token, it would not be >> indexed, and would perform very poorly. > > As you didn't bother to check SpamAssassin sources, let me clarify it for > you. All the SA queries use "id=? AND token=?". If something is changed, > it's usually for a reason. But thanks for the effort anyway.
My bad, I was thinking of id as an autoincrement type... not with its own semantic meaning. - -- David Morton <morto...@dgrmm.net> Morton Software & Design http://www.dgrmm.net - Ruby on Rails PHP Applications Maia Mailguard http://www.maiamailguard.com - Spam management for mail servers -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iD8DBQFLdvEoUy30ODPkzl0RAiqSAJoDB1ARJ1vGajHwE1pdEFHCbBAhogCgidNP j86yRAfmlVfXPzPnx0n+bnk= =9eEV -----END PGP SIGNATURE-----
