On Mon, Feb 13, 2012 at 1:51 AM, C J <[email protected]> wrote:
> Thanks Ian. This is a good place for me to start. I wonder if the block > size is configurable. Do you recall where you read about that? I'd like to > read up on it as well. > > -GN > > On Sat, Feb 11, 2012 at 12:16 PM, Ian Hobson <[email protected]> wrote: > > > On 10/02/2012 15:48, C J wrote: > > > >> The view file for my database is growing ten times faster than my > >> database. > >> View compaction recovers much of this used space, but I'd like to > minimize > >> how often I run view compaction. > >> > >> This is just a guess. > > > > IIRC updating the view has to write a new block for each view that has > > new data, even if that is only 1byte. > > > > Blocks are quite large (16K? - I forget). Compaction will recover this > > wasted space. > > > > I would try updating the view rather less often. Say once every 20 > > minutes, not every 10 seconds. Then > > each update has more data and less wasted space. > > > > Regards > > > > Ian > > > > >
