On Wed, Aug 22, 2012 at 06:11:46PM +0200, Benny Pedersen wrote: > if one like to have: > > l...@example.org j...@example.org,b...@example.org > > then dspam.virtual_uids most have both john and bob have same uid in > dspam terms, else dspam creates 200% more uneeded digest that is 100% > equal, this is a very big waste of ram resources if its in innodb with > mysql > > > here is my own current mysql table, its the one for single username pr > uid > > CREATE TABLE IF NOT EXISTS `dspam_virtual_uids` ( > `uid` int(10) unsigned NOT NULL AUTO_INCREMENT, > `username` varchar(128) COLLATE latin1_general_ci DEFAULT NULL, > PRIMARY KEY (`uid`), > UNIQUE KEY `id_virtual_uids_01` (`username`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci > AUTO_INCREMENT=11 ; > > remove UNIQUE KEY to have more then one username pr uid
Ok, seems a bit more clear. >From all of this I understand it is not *directly* possible from within dspam to have the usernames (without the @domain.tld part) used in the dspam_virtual_id DB. Am I right ? > Laurent are you listen ? :) I try to ;) ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
