I wrote: > > In experimenting with DBMail 2.0.7 (even with the changes I submitted > regarding the headername query, I can't get 2.1-trunk to run well > enough to work properly with both Mutt and Thunderbird), I discovered > (as perhaps some of you have) that storing changes to the attributes > is very slow when the folder has lots of messages (tens of thousands). > > 2.1.x may have fixed this, though the query in question is the same. > But in 2.0.7, the following query is responsible for the bulk of the > time spent in the update: > > SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='14' > AND (status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM > dbmail_messages WHERE mailbox_idnr='14' AND (status='0' OR > status='1') AND seen_flag=1 UNION SELECT 'c',COUNT(*) FROM > dbmail_messages WHERE mailbox_idnr='14' AND (status='0' OR > status='1') AND recent_flag=1
Umm...should I just submit a patch against 2.0.7 for this? What, if anything, do you guys want me to do about this? -- Kevin Brown [EMAIL PROTECTED]
