The Message Board screen now looks right in IE5.
That's because I wrote and ran a routine to toggle my display field off on all of them, then toggle it on only for the ones that the current site uses.
"Heritage" to refer to "new SI" on the current system works for me. Getting awfully confusing to think in terms of "Classic", "New", and "New-New".
In "Heritage" (is that what we're calling it?), threads inactive for longer than 30 days do not appear in the forum listings. Development shows something even fewer (7 days?). We really need an option to list "All" subjects within a forum if for no other reason than to help with the cleanup.
Ahead of you just a bit. I wrote forum.asp to accept a parameter ("numdays") and use it to determine how far back to go when pulling up boards. It'll eventually have links that make use of that parm.
For now, if you add "&numdays=" and some number to the end of the forum.asp URL, it'll list all threads that were posted to within that timeframe.
Actually, if forum.asp doesn't find any threads active in the past 7 days, it calls itself again with numdays set at 1000. To see an example of this, hit the Casino/Gaming forum link on the development site.
The development search (for subject) returns all hits.
Never could figure out why it works that way on Heritage (and Classic), but my educated guess is to keep the cache as clean as possible. A database this size lives or dies (performance-wise) based on the percentage of record retrievals that come from the cache instead of directly from the hard drives.
With 8 gig of memory and an extremely fast hard drive array, I don't see it being that big an issue.
Also, is it desirable to delete *old* threads with zero posts?
No. Unless they're spam or something like that. Keeping them around isn't a big overhead hit either, and I'll probably end up archiving those threads and moving them out of production on the new version of the site.
The Subject listing screen looks great! ;-)
Thanks. Although I ran across another snag today that's going to need to be addressed soon. Specifically, I'm grabbing new messages, private messages, etc every 10 seconds to update the new database.
Can't do that. At least not with public messages. Have to wait until the 15-minute edit window closes on a public message before importing it. So I'm going to have to zap a month or two worth of messages from the new site and re-import new ones and always check to make sure a message is at least 20 minutes old before importing it. |
