It's like Theo suggested. You likely have a structure that has many old tokens and fewer new tokens. If you want to shrink your database decide how many tokens you want to keep (for instance one million) and then determine the date that fits this (e.g. token count where atime > 'your time' is around 1 million). Then copy these one million records to a new table and swap it for the old table. Do not do it the other way (delete all records with atime < '....') as this will take much much much longer. Then adjust the bayes_vars table data and flush bayes_seen. Make a backup of the new data and then try an expiry.
Kai -- Kai Schätzl, Berlin, Germany Get your web at Conactive Internet Services: http://www.conactive.com
