--On Tuesday, March 15, 2016 1:31 PM +0000 Howard Chu <hyc(a)symas.com> wrote:
> I see the differences I've noted with at least 3 different
DBs of
> varying size now. I've dropped the 300kish one on ada.
With your 300k entry DB and config I see a full subtree search take about
10.4s with rtxnsize = 0, vs 11.7s with rtxnsize = 10000. Measurable
certainly, but not really noticeable.
As I noted, a 30:1 ratio seems to work ok. Now, if you go back to my
original mail, the problem is the default of 10k is clearly not sufficient
for any medium+ sized db. I think a mistake was made in setting the
default in 2.4.44 to anything other than zero. This is clearly an item
that needs tuning PER database, and should not have a default that creates
a severe performance penalty on databases > 300000 entries. As you can see
from my other emails, the further you get from the 30:1 ratio, the more
significant the penalty in performance. It would be interesting to know if
there are further ways to optimize the code so that the penalty is not so
severe. I.e., the next step would be to set the rtxnsize to 1000 with the
300k database and see if there are further optimizations to be had.
--Quanah
--
Quanah Gibson-Mount
Platform Architect
Zimbra, Inc.
--------------------
Zimbra :: the leader in open source messaging and collaboration
A division of Synacor, Inc