> 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.

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

With respect to getUserByName performance, I believe that you are also
mistaken, but there is a test you can try.  Put 25,000 users in the user
repository, but put only 2500 in the list database.  If the recipient list
matters, the performance will be 10 messages per second.  If the size of the
local repository matters, the performance will be much slower.

> That version of MySQL do You use?

3.23.42 on the test server.

        --- Noel


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

Reply via email to