On Tue, 22 Jun 2010 19:47:00 -0700 Gary Smith <gary.sm...@holdstead.com> 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.