On Fri, 13 Feb 2009, Paul J Stevens wrote:
Michael Monnerie wrote:
the index is useless, as you can only search "searchstring%" to use the
index. And if the index can't be used, it could be dropped altogether. I
did some searches with Kmail, the string I searched for shows what I
told Kmail to search (ZMI_*, e.g. ZMI_SUBJECT searched for subject)
All headers searches are performed against the headervalue table. The
subjectfield table is for thread=orderedsubject only. The other xxxfield
tables are used for sorting. So I guess you are correct: the index on
dbmail_headervalues.headervalue might as well be dropped.
Maybe it is used when inserting mail?
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
