On Tue, 22 Jun 2010 19:47:00 -0700
Gary Smith wrote:
> > I had a very dramatic performance improvement by switching bayes and
> > awl
> > databases to MySQL instead of the default BerkeleyDB. It costs more
> > RAM, CPU, and disk space, but scan times reduced dramatically. I'm
> > certain we were I/O bound before this change because we had plenty
> > of RAM and CPU available.
> >
>
> I agree to the bayes DB being MySQL. When we switched to that years
> ago it was night and day.
It'd be interesting to see the effect of bayes_learn_to_journal on gdb.
No-one ever mentions trying it, but it might be faster than MySQL.
AFAIK there's no equivalent for AWL, so that would have to be
turned-off to see the benefit.