On 02/02/2012 02:32 PM, Reindl Harald wrote:
> SELECT DISTINCT m.message_idnr FROM dbmail_mimeparts k LEFT JOIN
> dbmail_partlists l ON k.id=l.part_id LEFT JOIN
> dbmail_physmessage p ON l.physmessage_id=p.id LEFT JOIN dbmail_header h ON
> h.physmessage_id=p.id LEFT JOIN
> dbmail_headervalue v ON h.headervalue_id=v.id LEFT JOIN dbmail_messages m ON
> m.physmessage_id=p.id WHERE
> m.mailbox_idnr = 1406 AND m.status IN (0,1) AND v.headervalue LIKE
> '%charsettest%' OR k.data LIKE BINARY
> '%charsettest%' ORDER BY m.message_idnr;
Dude, that's a full mailbody search. Horde does that just to login??? I
can't believe that. And no, this does not sound like a regression in 3.0.
Full body searches will always trigger table scans since mail content is
*not* indexed. And won't be until we somehow implement full-text search
- which has all kinds of other issues.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
