[AgileWiki] Scrap tables?
Status: Beta
Brought to you by:
blaforge
From: Bill la F. <bil...@su...> - 2006-07-09 02:54:49
|
I am quite unhappy with multi-column tables stored in document content. 1. It is not too effficient from a storage perspective, as a change to a part of a document adds another copy of the whole document to the database--we don't do diffing. 2. It seems like an enormous duplication. Consider an alternative table rolon whose lsecs are the rows. Column values can then be stored as LEnts. I've been working on the simple accounting application. I'll note that with each row implemented as an LSec, you now have a journal for each account. Much better. And remember that, like rows, LSecs can be ordered. I just wish we had done this before declaring beta. Food for thought. Any comments? Bill |