Reaction Alert Notifications for Kiwi Green Accounts

  • 🐕 I am attempting to get the site runnning as fast as possible. If you are experiencing slow page load times, please report it.
Status
Not open for further replies.
Fun fact: 65,535 is the maximum number of alerts you can have for this site, because it was most likely using an unsigned two-byte integer. (Thank you again, @Overly Serious!) This was the result of 1.5 years of autistically not clicking on the alert button because I wanted to see if alerts would eventually be displayed as 99,999+, the actual number (eg: 140,489), or cause a site error on my end.

View attachment 5867514View attachment 5867515
Numbers like that just leap out at me as meaning something behind the scenes. It's curious - you could just scan on each pageload for messages to you that are unread dynamically but I suspect for performance reasons there's a separate running total and it's stored as an unsigned int.

Good on Null for planning to be able to handle the very laziest of Farmers with their unread alerts. @Idaho Battle Barn Were you never tempted to just click on it in the end and see if doing so would cause site performance to drop globally as it tried to retrieve 65,535 alerts from the database? :)
 
  • Autistic
Reactions: derpherp2
Oh, that explains it.
vivaldi_2024-04-01_12-07-01.png
 
Status
Not open for further replies.
Back