:: 29-Nov-1999 21:22 (Monday) ::
Thanks to some very dedicated snooping on the part of Bruce Wilson, our
“hired gun” transact-sql guru, we’ve got a somewhat better handle on the
problems with statsbox. The good news is, we now have a very long list
of things that we now know /aren’t/ the problem. :)
The bad news is, we still don’t know what the problem is. We’ve finally
decided that the next step is to rebuild the big rc5_64_master table
from the ground up. The involves copying 20 million records or so, and
then generating new indexes on that data. I suspect it will take a non-
trivial number of hours to churn through this data, so please be patient
as it progresses. To speed things as much as possible, you’ll see that
the stats web site has been disabled while it runs.
Once the table is rebuilt, we’ll have a much better feel for where we stand
on the slowdown issue.