[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Archive and purge
- Subject: Re: Archive and purge
- From: ..hidden..
- Date: Sat, 29 Dec 2012 22:00:18 -0700 (MST)
On Sat, 29 Dec 2012, Erik Huelsmann wrote:
If you don't mind me asking: what's the problem with the old volumes?
The fact that there's too much storage taken up by the data? Or does
your server get slower due to the amount of data it has to sift through?
Oh, a lot of little things which make working through day to day
operations a pain. The biggest pain is that I seldom have repeat
customers and with used books every book is unique even if you have two
copies of the same book-- so I build up a lot of cruft. Also, since the
data has been moved through three different accounting systems it has
I'm thinking I'd like to start clean when 1.4 goes stable.
In case of the latter, maybe we can alleviate the problem until the
older data has been archived? The thing is that if you don't use period
closes, then I can imagine the database having become too heavy.
However, if you close your books (enter a closed period) as of some
rather recent date (e.g. 2011-12-31) then the server can create a
"snapshot" to optimize queries for balances after that date.