I did a little innumerating last night. They seem to be deleting according to a script that is called from a foreach statement. "Delete where userid is in(query)" type of deal.
That's exactly what they're doing, IMHO. Che said the "delete tool" got "disconnected from the server" one night, which temporarily stopped the delete process. Given that and the fact that this delete is taking days instead of minutes, it's obvious that their method of deletion is an application of some sort (C#, VB, whatever) that is iterating the database and deleting records. In pseudo-code:
For each record in database
If record.transmission = "MT" and record.date < '8/25/07' Then
record.delete
Next record
That's the most moronic idea I've heard in a long time. The same thing could be accomplished with SQL, and execute in a few seconds. You wouldn't need cursors, and if you put the database in single-user mode you could temporarily disable index rebuilds. The entire process could be completed in a few minutes, tops. 100mil rows is child's play for any SQL Server built in the past ten years.
I'll wait to see what they do when this is all over, but given the tone of their messages thus far, I doubt they're going to do anything for us when it's completed.
Even if they did, it doesn't matter to me anymore. Che finally responded to my oft-repeated question of what they're going to do to prevent this from happening in the future. I asked specifically if they are going to make the database easier to "fix", or keep an eye on things closer, etc. His response was to accuse me of playing "what-if games", and essentially said they're not doing anything except simply deleting bad times now and will deal with future corruption if it happens.
http://forums.forzamotorsport.net/forums/permalink/929558/945839/ShowThread.aspx#945839To me it says they have done no work to avoid this in the future, they're completely happy with their RandomWipe solution, and if this happens again, they'll just do it again.
I wish there was a way to disable uploading times to the scoreboard. I don't really care to toss data into what might as well be a Wiki.
Heck, I REALLY wish GT didn't have a crap driving model.