Re: login to iRedAdmin-Pro is too slow

It's caused by an 'DELETE' command which used to delete mails older than 30 days (it's defined in libs/settings.py, default is 30 days).Still working on it, attachment's a tempary patch for iRedAdmin-Pro-MySQL-1.3.0 to solve it:

Re: login to iRedAdmin-Pro is too slow

- I already found index issue of "msg_idx_content_time_num (content, time_num)", will add it in iRedMail later.- I cannot believe that Amavisd doesn't create index for msgs.mail_id by default... terrible. Will add it too.

david222 wrote:

Do you see any problem if I execute

DELETE FROM msgrcpt LEFT JOIN msgs using(mail_id) WHERE isnull(msgs.mail_id)

What's the problem? Sorry, i'm not a MySQL expert.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

Re: login to iRedAdmin-Pro is too slow

hi Zhang,on this week i have made more test on my server and after latest restart i have solved any problem!! now logon without spam is on 3-4 seconds and with 160 spam email is 5 seconds ~!!

another minor bug i have found is when delete quarantine mail with "delete all in database"... after one week having 160 spam email i have click on "delete all in database" but have deleted only 28 mail... this is not a problem.. i have deleted all spam with select all and "delete selected"

Re: login to iRedAdmin-Pro is too slow

luciono wrote:

with 160 spam email is 5 seconds ~!!

5 seconds is slow, will try to tune it in later release.

luciono wrote:

another minor bug i have found is when delete quarantine mail with "delete all in database"... after one week having 160 spam email i have click on "delete all in database" but have deleted only 28 mail... this is not a problem.. i have deleted all spam with select all and "delete selected"

That's weird, it must be a bug in iRedAdmin-Pro. Will try to reproduce this issue and fix it in later release.

Thanks very much for your feedback.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

Re: login to iRedAdmin-Pro is too slow

Hi Huangbin,

It really is quite unworkable this way. I'm no SQL expert, but in a situation like this I would do this in two steps to avoid the "IN" statement. The first an update statement where you tag the records that are to be deleted in the msgrcpt table, using a join. And a second step in which you delete the tagged records.