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 [''lord...@lordvan.com ' '] > An: DBMail mailinglist [''dbmail@dbmail.org ' '] > 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 >>> '%<''da5c65a8e90626e027641f97fe43b...@yyyyyy.eu ' '%' >>> 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 >> ''DBmail@dbmail.org ' ' >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail >> >> > </span> > -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
