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 > >
