> Yes, the McKoi is slower MySQL. But I think it's no cause of this
> behavior.

Since all of my tests are with MySQL, I concur.  You probably didn't read my
latest message, which was posted about 20 minutes before your replies.

> I mean that in spool the letter is placed. This letter contains all
> emails of list. May be better to break this for some letters that will
> contain part emails of list.
> For example one letter was spooled with 'recipients' like
> testUser1TestUser2...testUser9999testUser10000

That is the same thing that I see here.  The list is large, but I'm not
convinced at the moment that partitioning it would help.

Sounds like you are using similar test data to what I devise.  I use this
program to populate a script:

public class t
{
  public static void main(String[] args)
  {
    int loop = Integer.valueOf(args[0]).intValue();
    System.out.println("use test;");
    for (int i = 0; i < loop; i++)
    {
      System.out.println("insert ignore into lists values('test', 'user" + i
+"@localhost');");
      System.out.println("INSERT IGNORE INTO users (username, pwdHash,
pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias) VALUES
('user" + i + "',NULL,NULL,0,NULL,0,'');");
    }
  }
}

and then run the script through mysql.

> With MySQL It is impossible to check for list more 2500 users. The James
> throws a exception "javax.mail.internet.ParseException: Out of data at
> position 5" for mail list with 3500, 5000, and more users.

I cannot reproduce that result, and I have tested up to 10000 users.
Looking at your data, however, it appears that your sample data does not
include the "@" and domain parts of the address.

        --- Noel


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to