You wrote 30 мая 2003 г., 19:19:20:

>> I see that speed for list about 1000-2000 users is bigger.
I>> f 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.

NJB> With respect to memory, you are mistaken.  The location where the memory is
NJB> lost is somewhat surprising.  sqlResources strings appear to be taking up
NJB> all of the memory.  There is a separate copy of them for each user mailbox.
NJB> The amount of space is directly related to the total number of mailboxes
NJB> instantiated, not the number per message.
OK.

NJB> With respect to getUserByName performance, I believe that you are also
NJB> mistaken, but there is a test you can try.  Put 25,000 users in the user
NJB> repository, but put only 2500 in the list database.  If the recipient list
NJB> matters, the performance will be 10 messages per second.  If the size of the
NJB> local repository matters, the performance will be much slower.
You're right.
I re-tested for 25,000 users in user repository and 2500 in mail list.
The delivery speed is less in 3 times.

>> That version of MySQL do You use?

NJB> 3.23.42 on the test server.

NJB>         --- Noel


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




Best regards, Eugene                          mailto:[EMAIL PROTECTED]


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

Reply via email to