Am 02.02.2012 19:33, schrieb Paul J Stevens: > 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.
repeatable, everytime i touch a login with horde3 using IMAP as authentication this happens > And no, this does not sound like a regression in 3.0. but it is same data, same machine, same horde with 2.2 no problem since years > 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. there is a hughe difference between table scan and "copy to tempoary table" seems to be triggered by some sort/distinct doing a full search in thunderbird on content and activate "search on server" does not trigger this -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
