Quanah Gibson-Mount wrote:
--On Saturday, March 12, 2016 10:32 AM +0000 Howard Chu hyc@symas.com wrote:
So apparently, you want the ration to be no more than 30:1, otherwise perfomance degrades substantially.
On a 1M entry database I see no performance difference between using the default rtxnsize (10000) and setting it to zero. Verified using both head and RE24.
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.