I'm overhauling the backend that generates our statistics page. We're currently holding 76,544,103 status reports submitted by the Windows Update Agent on Windows 2000, XP, and Vista. That's about how many updates have been installed (or attempted to be installed) since we started collecting stats in October 2022!
My really inefficient database that was collecting this data is currently using 61 GB, on a server with 75 GB available. The stats page used to update every 15 minutes, then every 30 minutes, then every hour, and at this point it takes that full hour to gather all the data to be displayed.
So I'm moving it to a database that's way better for this kind of thing (moving from MariaDB to Clickhouse). It'll take a bit of time for me to work on that. We're still collecting the reports, they just won't show up on the page for a while. And maybe we can even add some new interesting stats. I've been curious to make a leaderboard of the most error-prone updates, and maybe even support going back in time to see past weeks and months' stats.
We already have 8,768 reports queued to be processed after the new database goes live, and that's only from the past 12 hours. But it's one of those "good problem to have" things - I never could have imagined 206,900+ people would be using this thing I randomly threw together one day a few years ago. So, seriously, thanks for forcing me to do more work!