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
