You wrote 30 мая 2003 г., 18:08:39: >> Yes, the McKoi is slower MySQL. But I think it's no cause of this >> behavior.
NJB> Since all of my tests are with MySQL, I concur. You probably didn't read my
NJB> latest message, which was posted about 20 minutes before your replies.
Yes. I has read your letter after sending. Sorry.
>> 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
NJB> That is the same thing that I see here. The list is large, but I'm not
NJB> convinced at the moment that partitioning it would help.
I see that speed for list about 1000-2000 users is bigger.
If first to process the first part then the second and etc. then the mean
speed will be the same as for each part. The same for memory.
Or I'm mistaken?
NJB> Sounds like you are using similar test data to what I devise. I use this
NJB> program to populate a script:
NJB> public class t
NJB> {
NJB> public static void main(String[] args)
NJB> {
NJB> int loop = Integer.valueOf(args[0]).intValue();
NJB> System.out.println("use test;");
NJB> for (int i = 0; i < loop; i++)
NJB> {
NJB> System.out.println("insert ignore into lists values('test', 'user" + i
NJB> +"@localhost');");
NJB> System.out.println("INSERT IGNORE INTO users (username, pwdHash,
NJB> pwdAlgorithm, useForwarding, forwardDestination, useAlias, alias) VALUES
NJB> ('user" + i + "',NULL,NULL,0,NULL,0,'');");
NJB> }
NJB> }
NJB> }
NJB> and then run the script through mysql.
I use the attached Java class to fill database.
First users are created through telnet, then the table 'list' is being
filled.
>> 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.
NJB> I cannot reproduce that result, and I have tested up to 10000 users.
NJB> Looking at your data, however, it appears that your sample data does not
NJB> include the "@" and domain parts of the address.
Hm. The username with domain part is in the table 'lists' like - [EMAIL PROTECTED]
That version of MySQL do You use?
And let me re-check again.
NJB> --- Noel
NJB> ---------------------------------------------------------------------
NJB> To unsubscribe, e-mail: [EMAIL PROTECTED]
NJB> For additional commands, e-mail: [EMAIL PROTECTED]
Best regards, Eugene mailto:[EMAIL PROTECTED]
CreateUsers.java
Description: Binary data
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
