Re: Sending mail slowly
Paul J Stevens <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
disable suppress_duplicates. That's what's triggering the query. On 10/16/2014 08:19 PM, Ralph Ballier wrote: > I have this command executed directly in the database. He referred to the mailbox "sent". This 120,000 lines were displayed. That's why it took so long apparently. I then set up a new mailbox for "sent". Now lasts 3 seconds to send. > > Ralph > > ----------------ursprüngliche Nachricht----------------- > Von: Thomas Raschbacher [''[email protected] ' '] > An: DBMail mailinglist [''[email protected] ' '] > Datum: Wed, 15 Oct 2014 13:21:54 +0200 > ------------------------------------------------- > > >> On 2014-10-15 07:42, Ralph Ballier wrote: >>> Hello, >>> >>> I use dbmail 2.2.18. >>> >>> I found this in maillog: >>> >>> Oct 15 07:34:15 xxx dbmail/imap4d[9461]: Message:[db] >>> dbmodule.c,db_query(+149): slow query [SELECT message_idnr FROM >>> dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id >>> JOIN dbmail_headervalue v ON v.physmessag >>> e_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE >>> mailbox_idnr = 3047 AND status IN (0,1) AND headername LIKE >>> 'MESSAGE-ID' AND headervalue LIKE >>> '%<''[email protected] ' '%' >>> ORDER BY message_idnr] took [24] seconds >>> >>> Is this a true problem? What can I do? Sending mails is sometimes >>> very slowly. >>> >> >> Hi. >> >> Apart from if it is a problem or not ... this has nothing to do with >> sending mail. This seems to be an IMAP searchfor a certain MESSAGE-ID >> (maybe to set a flag or something after sending) ? >> >> Regards >> _______________________________________________ >> DBmail mailing list >> ''[email protected] ' ' http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >> >> > </span> > -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin www.nfg.nl/[email protected]/+31.85.877.99.97 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail