On 8/19/05, Quanah Gibson-Mount <quanah@stanford.edu> wrote:
> Ah. The only thing I'm setting from those options is several "index"
> entries. Anything in particular you recommend I experiment with?
cachesize and idlcachesize
We only have ~1300 entries in our database, so I left cachesize at the
default (1000) and set idlcachesize to 200. It'll be interesting to
see how that changes things.
That does seem small, but after reading the documentation you linked
to and playing with db_stat, it appears we were getting 85% to 97%
cache hits, depending on the attribute.
In the name of experimentation, I doubled it to 4MB. I'm going to
spend some time reading about the bdb tweaks and see what I can
optimize. However, since our database is so very small, I'm not
expecting dramatic changes...