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> -- Mit freundlichen Grüßen Ralph Ballier _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
