> >You can model your domain data in a way, that no > >relation goes out of transaction ( say transaction > >knows nothing about accounts, or whatever is in > your > >domain ) > > > >And then you have object "month", which has > collection > >of transactions. And this collection happens to > select > >only those which belong to certain month. > >( either date based, or with ID of month ) > > > >Then you can archive your transactions away without > >breaking relations. > > Let me see if I understand. I need a single Ledger, > Journal, Session, > etc table instead of one table per month as now. > These each hold six > months worth of data instead of one month as now. I > also need > LedgerArchive, JournalArchive, SessionArchive tables > (or files) to > store rollover data permanently. Instead of creating > new monthly > tables during the monthly rollover, I lock the > tables and move month > 7 (6+1) to the archives. Right? > > The only problem I see is that I have to scan six > months of > transactions to compute an account balance as now, > and this is a > high-volume computation (nearly every web page needs > the account > balance). But those monthly tables are a real PITA > so maybe its worth > it. What do you think? > > Do you know a way to cache the account balance each > month?
I'm not in accounting business, so I may not have throrough understanding of needs of your domain model. But you can have "montly balance" objects, which hold total amount of coming / goinng money for account. Once they are calculated, transactions can be archived away. BTW, you seems to be in education business? I'm designing "virtual classes" system right now. Maybe we can share experiences? regards, ===== ----[ Konstantin Pribluda ( ko5tik ) ]---------------- Zu Verst�rkung meines Teams suche ich ab Sofort einen Softwareentwickler[In] f�r die Festanstellung. Arbeitsort: Mainz Skills: Programieren, Kentnisse in OpenSource-Bereich ----[ http://www.pribluda.de ]------------------------ __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
