Item1691: Create new database accelerator plugin

For a long time it's bugged me that we don't haven't the benefit of DBCacheContrib with standard query searches.

Now we do.

When used with Berkeley DB, initial benchmarks indicate scalability up to tens of thousands of topics.

-- CrawfordCurrie - 05 Jun 2009

I just did pseudo install and tested, following the instructions. From a svn checkout. This is really great, looking forward to be able to download and install into production system.

Is it just testing that's keeping it from being released to the extensions web?

-- LarsEik - 13 Aug 2009

Not just that. I ran some benchmarks and I'm not happy with the performance of the BDB solution over large webs - though the Storable search seems OK. I don't regard the performance advantage of this plugin high enough to make it worthwhile releasing.

I think the performance problems in the BDB version are purely and simply the encoding used to flatten out the data into a BDB, and then the rebuilding of that data in memory when a search is performed. The overhead is considerable.

My interest has shifted to a native database store, as that's the only way to leverage DB indexed searching.

Anyone with an interest in this plugin should feel free to test/benchmark/release it if they want. I moved this report into "Waiting for Feedback" state to reflect this.

-- CrawfordCurrie - 13 Aug 2009

Abandoned this work, due to lack of interest.

-- CrawfordCurrie - 28 Aug 2010