With data, it is almost always easier and cheaper to start clean and import into the new database that to try to fix a badly designed schema and poorly written data retrieval code. Especially true with all the really good new tools for cleaning and importing data.
Facebook's only issue with moving data to a new system is volume - the actual time it would take to copy, clean and test the billions of records and transactions. Another way might be to only put new stuff in the new system, except for the members and archive all the historical posts, as almost all the interaction - adds, comments, shares, etc. is on very recent information. On Tue, Jul 12, 2011 at 5:54 AM, Jerry Barnes <critic...@gmail.com> wrote: > > With the capital facebook has, I'd say build the perfect system from scratch > and then import the existing data. Certainly not feasible for many > businesses, but finances shouldn't be a problem for facebook > > J > > - > > Ninety percent of politicians give the other ten percent a bad reputation. - > Henry Kissinger > > Politicians are people who, when they see light at the end of the tunnel, go > out and buy some more tunnel. - John Quinton > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:340314 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm