Cb is back in business

Two weeks ago, I looked into why Cb was failing once more, as Cb was giving MySQL warnings, and the after that I cleaned up the list of active blogs. Several people reported that, for example, the Blue Obelisk RSS feed was down. Today, I found the cause of the lack of updates: the tags table had grown too much in size, and the Postgenomic.com software's SQL queries are not really optimised... So, our host (Dreamhost) renamed the table to fix the massive load on the MySQL server, causing the MySQL warnings, but also the lack of updates. I emptied the tags table, as the tags are not really crucial anyway, making the website show up nicely again, and hopefully making the update script not fail any more, either...

60 day old blog posts still important?

Last week some of you noted that the Chemical blogspace was no longer nicely updated every X hours. The code is not optimized for performance and the number of old posts (about 10k in 6 months!) made the update_posts.pl break down. Or really, the DreamHost service killed the process after taking too long. Fair; it's the online way to keep the systems from not breaking down over one website. I already had split up processing the first 75 blogs and the rest into two separate jobs.

So, now I made a more radical change, and deleted old posts older than 60 days. That's ancient history, not?