amavis quarantine table question
Jernej Porenta via amavis-users
amavis-users at amavis.org
Mon Feb 24 18:36:13 CET 2014
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.
More information about the amavis-users