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