That would be great. It's been a pretty frustrating launch because there are very few module developers who really take the time to optimize their queries and indexes. Most don't test with large databases apparently. I've had to add proper indexing to nearly every module I've purchased.
On a similar note, I'm running a trace on my database and am seeing the OptInEmail_GetOptInCategoriesByOptInID stored procedure called 3 or 4 times every few minutes. I can't figure out what is triggering the database call. I don't think anyone is going to the admin page that frequently. And on a database of this size, this query takes up to 40 seconds. Can you think of any place that would trigger this stored procedure? (I've also turned off the scheduler)