Maikel,
I have this same problem on a memory starved server. The sql below
happens when you open a large mailbox with a lot of unread messages
using thunderbird.
"Maikel Dollé [Hebbizz BV]" wrote:
> # Query_time: 56 Lock_time: 0 Rows_sent: 447 Rows_examined: 9444548
> SELECT message_idnr,headername,headervalue FROM dbmail_headervalue v
> JOIN dbmail_messages m ON v.physmessage_id=m.physmessage_id JOIN
> dbmail_mailboxes b ON m.mailbox_idnr=b.mailbox_idnr JOIN
> dbmail_headername n ON v.headername_id=n.id WHERE m.mailbox_idnr = 2700
> AND message_idnr BETWEEN 15651805 AND 16208824 AND lower(headername) IN
> ('date','to','cc','from','subject','x-priority','importance','priority','content-type');
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
