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 weird inconsistencies. 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. > > Bye, > > Erik. > > ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_123012 _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
