Ooh, sorry, but I forgot to answer one of your questions. You would store the deltas in binary columns in a database table named something like Revision, which would also have columns for version, date, author, the foreign key to the table containing the current version (stored as HTML, I assume), and any other attributes you care to store along with each revision. Makes it easy to see a list of all revisions.
Make sure to index on the version number and foreign key to make processing rollbacks perform well. Respectfully, Adam Phillip Churvis President Productivity Enhancement > -----Original Message----- > From: Mike Kear [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2008 10:17 AM > To: CF-Talk > Subject: Re: How to Archive in a CMS > > I'm sorry if i'm being a bit dense, but how would that work in a > CF8Enterprise/Win2003/MSSQLServer2005 setup? How would I store the > binary negative deltas? > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > On Tue, Sep 23, 2008 at 9:45 PM, Adam Churvis > <[EMAIL PROTECTED]> wrote: > > Mike, > > > > Why not just store the current version in your live CMS table, then > store > > all the binary negative deltas in a revisions table? That reduces > your > > storage requirements to almost nothing, it makes history retrievals > > lightning fast, and you can display any version from any point in > history > > (or rollback to that point) with a simple binary operation. > > > > Respectfully, > > > > Adam Phillip Churvis > > President > > Productivity Enhancement > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
