Re: [Dbmail] Sending mail slowly

2014-10-25 Thread Paul J Stevens
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

Re: [Dbmail] Sending mail slowly

2014-10-16 Thread Ralph Ballier
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

Re: [Dbmail] Sending mail slowly

2014-10-15 Thread Thomas Raschbacher
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 dbma

[Dbmail] Sending mail slowly

2014-10-14 Thread Ralph Ballier
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