Given the optimizations of the past few days, the requests to the site in roughly the previous 24 hours of uptime have been:
Shoutbox Refresh: 44.90%
Notifications: 12.32%
Users Online: 7.93%
Users In Shoutbox: 13.36%
Technical details:
- Users in shoutbox now has its own table, similar to the users online table.
- Users in shoutbox is no longer a query on the enormous sessions table joined with the users table.
- Users in shoutbox query now only selects needed columns instead of *.
Post has been edited 1 time(s), last time on May 10 2017, 11:38 pm by Mini Moose 2707.
https://www.collaborativefund.com/blog/how-this-all-happened/
https://thelastpsychiatrist.com/2012/11/hipsters_on_food_stamps.html
https://youtu.be/vyiXaCRwZTs
https://thelastpsychiatrist.com/2011/09/how_to_be_mean_to_your_kids.html
http://lab.cccb.org/en/renata-avila-the-internet-of-creation-disappeared-now-we-have-the-internet-of-surveillance-and-control/
https://thelastpsychiatrist.com/2012/11/hipsters_on_food_stamps.html
https://youtu.be/vyiXaCRwZTs
https://thelastpsychiatrist.com/2011/09/how_to_be_mean_to_your_kids.html
http://lab.cccb.org/en/renata-avila-the-internet-of-creation-disappeared-now-we-have-the-internet-of-surveillance-and-control/
