|
Members in Shoutbox
None.
Shoutbox Search
Shoutbox Commands
/w [name] > Whisper
/r > Reply to last whisper /me > Marks as action Shoutbox Information
Moderators may delete any and all shouts at will.
|
Global Shoutbox
Please log in to shout.
[2017-5-09. : 12:06 am]  Moose -- Getting slow again. Guess someone is trying to use something that isn't the shoutbox, lel.[2017-5-09. : 12:02 am] Moose -- Indeed, but I can live with the criteria for "worst" being "kind of bad" instead of "DoS the site"[2017-5-08. : 11:59 pm] Suicidal Insanity -- Trust me, there always is a new worst part of the project.... it never ends[2017-5-08. : 11:57 pm] Moose -- All of the other shitty optimization will still kill us, but at least the shoutbox won't kill it anymore.[2017-5-08. : 11:57 pm] Suicidal Insanity -- ok.... "Some fancy color for your name? Devlin please give me proper descriptions! "[2017-5-08. : 11:56 pm] Moose -- Yeah. The high page number is static and determined on page load so that wasn't what was killing it anyway.[2017-5-08. : 11:56 pm] Suicidal Insanity -- Ok, so I can leave the shoutbox tab open without worrying about crashing the site  [2017-5-08. : 11:50 pm] Moose -- Mini Moose 2707Mini Moose 2707 shouted: Suicidal Insanity Suicidal Insanity It doesn't refresh the last page number, so it will become inaccurate over time instead. Furthermore, the query for non-deleted shouts that are public or whispered to you or whispered by you is the concatenated index now [2017-5-08. : 11:49 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Does it slow down when I have the 'global shoutbox' page open... because it parses every single entry in the DB to figure out it has to print ' ... 2777' as the last page index? xD xD Suicidal InsanitySuicidal Insanity shouted: on every AJAX refresh It doesn't refresh the last page number, so it will become inaccurate over time instead.[2017-5-08. : 11:48 pm] Moose -- HOLY SHIT WE HAVEN'T HAD THIS MUCH CONVERSATION WITH MORE THAN FIVE PEOPLE ONLINE IN MONTHS[2017-5-08. : 11:47 pm] Suicidal Insanity -- Does it slow down when I have the 'global shoutbox' page open... because it parses every single entry in the DB to figure out it has to print ' ... 2777' as the last page index? xD xD[2017-5-08. : 11:47 pm] Moose -- AposApos shouted: It might be the case LOL I mean, it is loaded on every page ever, so I could see it clogging things up, especially with search bots spidering the site...[2017-5-08. : 11:47 pm] Moose -- Mini Moose 2707Mini Moose 2707 shouted: Suicidal Insanity Oh, it's structure only. And actually, the more recent versions of the structure and the production copy of that DB have the hashes and IP address columns removed.[2017-5-08. : 11:46 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Mini Moose 2707 -- Suicidal Insanity <- SEN V4. The github page said something about a database dump, haven't taken a look at the contents yet Oh, it's structure only.[2017-5-08. : 11:46 pm] Moose -- What if it turns out the shoutbox was actually the culprit the entire time? LMAO[2017-5-08. : 11:46 pm] Suicidal Insanity -- Mini Moose 2707 -- Suicidal Insanity <- SEN V4. The github page said something about a database dump, haven't taken a look at the contents yet[2017-5-08. : 11:46 pm] Moose -- Hot damn, just went to some random page numbers of the shoutbox and didn't like ... die waiting.[2017-5-08. : 11:45 pm] Moose -- Though I made a nice concatenated index that should make loading the shouts faster.[2017-5-08. : 11:44 pm] Moose -- Yeah, but not really under load, we'll see how it goes as more clients connect.[2017-5-08. : 11:43 pm] Moose -- Also, using the primary key of shout id for order by clauses in a bunch of places instead of time, which wasn't even indexed SMH[2017-5-08. : 11:43 pm] * Apos now knows that*[2017-5-08. : 11:43 pm] *Apos didn't know that*[2017-5-08. : 11:42 pm] * lil-Inferno emotes*[2017-5-08. : 11:41 pm] *Moose optimized shoutbox slightly O_O*[2017-5-08. : 10:42 pm] Moose -- Mini Moose 2707Mini Moose 2707 shouted: "SELECT * FROM `shoutbox` WHERE sb_deleted NOT IN (0, 1)" MySQL returned an empty result set (i.e. zero rows). (Query took 0.0030 sec) <-- this is how you know this shit should be a boolean LMAO Boutta change it to a boolean live and see if that actually helps, anyone care about downtime at this point? LMAO. I really should make a maintenance mode that I just flick on and off and maybe even a scheduled maintenance window. Probably need those in the future anyway, for deploying updates and shit.[2017-5-08. : 10:39 pm]  DevliN -- jjf28jjf28 shouted: ohi DevliN; moose took ur job I've been doing little more than paying the bills for a long long time now, so fine with me.  [2017-5-08. : 10:37 pm] Moose -- jjf28jjf28 shouted: ohi DevliN; moose took ur job MOOSE GON GIVE IT TO YA, FUCK WAITIN FOR YOU TO GET IT ON YA OWN, MOOSE GON DELIVER TO YA[2017-5-08. : 10:35 pm] Moose -- "SELECT * FROM `shoutbox` WHERE sb_deleted NOT IN (0, 1)" MySQL returned an empty result set (i.e. zero rows). (Query took 0.0030 sec) <-- this is how you know this shit should be a boolean LMAO[2017-5-08. : 10:35 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Did that dump include passwords etc? I remember that all the passwords were leaked quite a while back Which dump?[2017-5-08. : 10:34 pm] jjf28 -- Mini Moose 2707Mini Moose 2707 shouted: I COULD HAVE JUST GIVEN YOU THE LINK! TAKE IT! TAKE IT! you don't sound like you want it anymore  [2017-5-08. : 10:33 pm] Suicidal Insanity -- Did that dump include passwords etc? I remember that all the passwords were leaked quite a while back[2017-5-08. : 10:31 pm] Moose -- Also, the v4 code is some w/e that Doodle wrote many years ago that was recently fixed up. The v4 code doesn't really look like the v6 code at all.[2017-5-08. : 10:28 pm] Suicidal Insanity -- Damn, th tab I ran the search on hung up, and I can\'t open a new tab on my laptop. You weren't joking. But the tab with the search is still autoupdating. (And maybe I can post this from my desktop)[2017-5-08. : 10:23 pm] Suicidal Insanity -- So if the site freezes for the next 5 mins, its because I ran a search[2017-5-08. : 10:22 pm] Suicidal Insanity -- The shoutbox has search. Let me guess: the search parsing is written in PHP.[2017-5-08. : 10:22 pm] Suicidal Insanity -- LOL github is also slow loading the SEN project page. Its infected[2017-5-08. : 10:21 pm] Moose -- Yeah, you were pretty much either in the shoutbox when it was posted or it's forever lost ROFL |
Members Online: lifebot