…much as possible, freshenup.pl now not only performs all its setStory() calls quickly, but also refuses to do so unless the changes are significant. Once every 10 (not 3) minutes, it does a thorough sweep and updates not only .shtml but commentcount and hitparade; the other 9 invocations it only touches .shtml files and only the most recent 3.
process from re-asking the DB for it at once. Have freshenup.pl do all its setStory() calls at once, to extend the length of time for which the stories table query cache is valid. Minor bugfix, I think, in precache_gse.pl.
smarter about knowing when to give up.
different queries, it's best to update this var much less often than I'd set it up for originally. Timespec changed from every 3 minutes to once a day.
getStoriesEssentials() work from the reader DBs and get the writer DB taking some of that load.
nexus tids and non-imaged tids up top.
by primary key, potentially dramatically speeding up index.pl on a site with a large number of stories in its mainpage.
…ning who wants to moderate; and count sectional stories for the skinindex using a more robust method.
normally be over 99% on a busy site.