|
>>
|
No. 3048
>>3046
I don't sysadmin anything terribly important nowadays. But, I mean, are image boards terribly important? Do "chans" really need 100% uptime? And also, image board sites have clearly proven themselves to have a long tail when it comes to traffic and activity. So maybe 4chan and 7chan need supermegaoptimization black magick, but for just about everyone else, their sysadmins' lives will be better served by just taking a walk outside and getting some fresh air.
I agree that doing an SQL query for every page load seems kind of wasteful, but presumably a table with a bunch of IP addresses could be cached entirely in memory by the RDBMS without any trouble - and for stuff like temp bans, I think an SQL table would actually be quite useful; have a cron script that runs every half hour to unban IPs and such. And I'm really just guessing here, but I wonder if it would be possible to have it so that, if the client is using HTTP/1.1's KeepAlive, we only need to hit the SQL table once per connection… Hmm.
|