On 24/02/14 14:51, Deeztek Support via amavis-users wrote:
The documentation states that in the quarantine table the mail_text
column should be of data type blob instead of text as it was suggested
before. However, data type blob cannot be indexed will full text in
mysql thus queries against the mail_text column take a ridiculous amount
of time to complete. If I was to change the data type to text, what
effect if any would this have to the functionality of amavis in general?
What kind of information are you extracting from quarantine table?
IMHO, other tables - msgs, msgrcpt, maddr - provide enough information
for (at least my) "full" text search queries.
cheers, J.
