I'm sorry that you had this happen to your table, but as soon as I saw your posting I couldn't help but wonder what kind of performance you were getting out of your app before the table crashed. I think we would all like to hear how fox works with such a large amount of data. Thanks.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!