Item1691: Create new database accelerator plugin

Priority: Enhancement
Current State: Closed
Released In:
Target Release: n/a
Applies To: Extension
Component: QueryAcceleratorPlugin DBCacheContrib
Reported By: CrawfordCurrie
Waiting For:
Last Change By: CrawfordCurrie
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

ItemTemplate edit

Summary Create new database accelerator plugin
ReportedBy CrawfordCurrie
SVN Range SVN 4041: Foswiki-1.1.0-dev, Tue, 26 May 2009, build 3980
AppliesTo Extension
Component QueryAcceleratorPlugin DBCacheContrib
Priority Enhancement
CurrentState Closed
Checkins distro:598a4d46c2c2 DBCacheContrib:7ae89327d8f6 distro:48013951dae1 distro:1a1a64699139 DBCacheContrib:dc7909ce074c Rev 6072 not found
TargetRelease n/a
Topic revision: r11 - 28 Aug 2010, CrawfordCurrie
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy