These were messages sent by the "Silicon Investor" account or other system-generated messages, right? Everyone who's got old system-generated messages hanging out in their Inbox (likely scrolled off their screen if they keep everything in the Inbox rather than foldering their keepers) should gradually see the count go down by 30-something.
While I'm here, an update on what the heck I'm doing and why not much visible progress is being seen on SI Dev for the past two days.
1. Trimming down the folder_links table (which handles what's in your Inbox and in folders you've created). This started out at 19.7M rows before the crash. Currently it's down to 8M rows and should end up at 2.6M rows. This involves deleting folder_links in folder 1 (Inbox) that point to system-generated messages, and deleting links to messages in Folder 3 (Trash). Then deleting what we call "glitch" rows: links to public messages not written to you. Once it's reached its target size, it will become possible to have the Dev site mirror it in near-realtime.
2. I started working on read_replies.aspx but ran into a brick wall in my knowledge and am having to spend quite a bit of time reading. Basically, how to have two recordsets open at the same time in ASP.NET. The brick wall is a mental barrier to assimilating how .NET deals with what I'm accustomed to doing as recordsets. They're "Datasets" in .NET and apparently, once populated, act much like the Recordsets I'm used to, but are not connected to the database. Once I fill this gap in my knowledge, I'll need to apply it to the pages I've written so far, but that shouldn't take too long, once I've climbed the learning curve.
I'd run into a problem earlier where I wasn't closing database connections appropriately and I'm still not sure I am. I need to get it through my thick skull that in .NET, you open your db connection, make the datasets you need, then disconnect from the db. Quickly.
The kludge I've implemented is to make sure I'm doing it "right" in the busiest pages, increase the db connection pool to 5000 (default is only 100) and to have msgboardmain.aspx (what I think is a relatively little-used routine) do a "garbage collection" to free up pooled db connections that haven't been used in a while but haven't been explicitly closed.
I think it works, as there are only 66 pooled connections on that box right now.
Oh, and I've noticed that the Hot Stock Boards frame on the homepage is broken. We've also experienced some other intermittent weirdness on that box (like pages that won't load at all, then suddenly they will -- with nothing being changed), so after I'm done paring down folder_links, we'll reboot 'er and see what happens. |
