|
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-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[2017-5-08. : 10:19 pm] Moose -- Ya, I mean, I posted the v4 repo so you would have seen it there, too LMAO[2017-5-08. : 10:16 pm] jjf28 -- scmd/chkd? probably not, I'd consider getting my features into your project and closing mine depending on the quality and stability of your code, whether the architecture supports some of the more ridiculous features in my head and whether or not I'd get git admin status and a creators credit  [2017-5-08. : 10:10 pm] Suicidal Insanity -- If I say I'm looking forward to the GIT dump of the code... will you suddonly cancel that project?  [2017-5-08. : 10:09 pm] Suicidal Insanity -- You mean like C++? You can use enums in switch, but not enum_type_A | enum_type_B because that uses an operator to or them... but casting them to int and then ORing works again xD[2017-5-08. : 10:02 pm] jjf28 -- like preventing certain enums from being used in switch statements cause they're "not constants" or having no way to define a serializable value/data size for that enum[2017-5-08. : 10:00 pm] jjf28 -- Mini Moose 2707Mini Moose 2707 shouted: Note for new: Using magic numbers is pretty dumb period if the language supports enums a lot of languages have tons of dumb enum nuances tho  [2017-5-08. : 9:59 pm] Ashamed -- Mini Moose 2707Mini Moose 2707 shouted: Ashamed Just DoS. You don't need more than one machine to DoS this site LMAO I was talking about multiple clinets.. Since everyone has the options to do this.[2017-5-08. : 9:58 pm] Moose -- AshamedAshamed shouted: Suicidal Insanity exactly... by giving the user control over this you open up ways for users to DDOS you pretty much ha. Just DoS. You don't need more than one machine to DoS this site LMAO[2017-5-08. : 9:58 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Who cares about performance for going to opage 287... optimize for the common case But the code for the global shoutbox on page 1 and page 287 are the same thing with different limits[2017-5-08. : 9:58 pm] Ashamed -- Suicidal InsanitySuicidal Insanity shouted: Who cares about performance for going to opage 287... optimize for the common case exactly... by giving the user control over this you open up ways for users to DDOS you pretty much ha.[2017-5-08. : 9:57 pm] Moose -- And requirements is probably a bad word for me to use, since it's "requirements" extracted from the current implementation after the fact versus a specification it was designed to.[2017-5-08. : 9:57 pm] Suicidal Insanity -- Who cares about performance for going to opage 287... optimize for the common case [2017-5-08. : 9:56 pm] Ashamed -- Doing it this way though can make ajax request even longer.... YOu would need to put strict metrics into the system still.... You dont want people to be able to grab their own limit...[2017-5-08. : 9:55 pm] Ashamed -- and min... I would just change this to be a variable instead of static[2017-5-08. : 9:55 pm] Ashamed -- Mini Moose 2707Mini Moose 2707 shouted: Ashamed Yeah, but your shoutbox doesn't have requirements like "on load has to return exactly <user preference> amount of shouts" or the ability to arbitrarily go back to page 287 on demand (where the page number is adjusted by whispers and deleted shouts) This would be easy for me to do.. with my system already.. my shoutbox loads max[2017-5-08. : 9:55 pm] Suicidal Insanity -- As long as the query filters properly, you just need to set the LIMIT correctly and let the sql engine do it[2017-5-08. : 9:54 pm] Moose -- I mean, if we don't care about those requirements, then it's pretty easy to optimize LMAO[2017-5-08. : 9:54 pm] Moose -- AshamedAshamed shouted: $db->query('SELECT MIN(ID) FROM webchat_lines WHERE ts > DATE_SUB(NOW(), INTERVAL 12 HOUR)'); (That is how I do my shoutbox ajax) Yeah, but your shoutbox doesn't have requirements like "on load has to return exactly <user preference> amount of shouts" or the ability to arbitrarily go back to page 287 on demand (where the page number is adjusted by whispers and deleted shouts)[2017-5-08. : 9:53 pm] Ashamed -- $db->query('SELECT MIN(ID) FROM webchat_lines WHERE ts > DATE_SUB(NOW(), INTERVAL 12 HOUR)'); (That is how I do my shoutbox ajax)[2017-5-08. : 9:52 pm] Suicidal Insanity -- well you could nornalize the shoutbox... a table ID -> timestamp; a table ID -> text; a table ID -> user, etc[2017-5-08. : 9:51 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: Well fine.. select where whisper target == me or whisper target == null order by time desc limit 20, and put a index on the timestampe (Assuming its not a string xD xD) Nah, gotta have deleted != 0 and whisper == 0 and stores them as ints for some reason LMAO[2017-5-08. : 9:50 pm] Ashamed -- Suicidal InsanitySuicidal Insanity shouted: Well fine.. select where whisper target == me or whisper target == null order by time desc limit 20, and put a index on the timestampe (Assuming its not a string xD xD) yeah that is exactly how i told moose to do it yesterday lol[2017-5-08. : 9:49 pm] Suicidal Insanity -- Well fine.. select where whisper target == me or whisper target == null order by time desc limit 20, and put a index on the timestampe (Assuming its not a string xD xD)[2017-5-08. : 9:49 pm] Ashamed -- When I changed my queries to pull more ranges.. It increased my browser memory by like 6gbs lol[2017-5-08. : 9:47 pm] Ashamed -- I really need to setup rdp on my computer... I bought this new 4k monitor and teamviewer just doesn't work anymore ha[2017-5-08. : 9:47 pm] Moose -- Suicidal InsanitySuicidal Insanity shouted: So no select from shouts order by ID desc limit 20? No, because you might get whispers to other users. And I think it's ordered by timestamp instead of ID for reason, even though they're monotonically increasing.[2017-5-08. : 9:44 pm] Moose -- Note for new: Using magic numbers is pretty dumb period if the language supports enums[2017-5-08. : 9:44 pm] Voyager7456 -- Suicidal InsanitySuicidal Insanity shouted: was he a python coder? afaik it took until python 3 or so for them to get enums  [2017-5-08. : 9:44 pm] Moose -- Note for new programmers: using integers for magic numbers when there's only ever two values is bad.[2017-5-08. : 9:44 pm] Ashamed -- Suicidal InsanitySuicidal Insanity shouted: So no select from shouts order by ID desc limit 20? I tested this on my ajax shoutbox.. and i was able to kill the performance of my website pretty fast lol...[2017-5-08. : 9:44 pm] Suicidal Insanity -- was he a python coder? afaik it took until python 3 or so for them to get enums [2017-5-08. : 9:43 pm] Moose -- Nah, Devourer used integers with magic values for some reason instead of booleans in too many places LMAO[2017-5-08. : 9:43 pm] Ashamed -- Mini Moose 2707Mini Moose 2707 shouted: Example: The shoutbox populate/refresh will query all shouts that are not deleted and are not whispers, unless they're whispers to you. We call this an indexing nightmare. I was gonna make a quick for each for this... I need to find some time though ><[2017-5-08. : 9:42 pm] Ashamed -- Mini Moose 2707Mini Moose 2707 shouted: Some of them are very poorly optimized. In an ideal world, they would all be "small" and take a miniscule amount of time. oh i guess a full rsync right at the migration shouldn't be that bad.[2017-5-08. : 9:42 pm] Suicidal Insanity -- does the database have 1 table with 100 bool columns for 'IsUserEntry' 'IsThreadEntry' 'IsPostEntry' etc? [2017-5-08. : 9:42 pm] Moose -- Example: The shoutbox populate/refresh will query all shouts that are not deleted and are not whispers, unless they're whispers to you. We call this an indexing nightmare.[2017-5-08. : 9:36 pm] Moose -- Some of them are very poorly optimized. In an ideal world, they would all be "small" and take a miniscule amount of time.[2017-5-08. : 9:31 pm] Suicidal Insanity -- Minimoose: Are they small, or are they the ones that kill the performance? Ajax is hit with a much high frequency than page loads after all...[2017-5-08. : 9:18 pm] Moose -- AshamedAshamed shouted: Mini Moose 2707 I told you the db wouldn't take that long... but you really should of waited until the last step for db migration ><. Now you will have to do it again. and or miss data It's the DLDB. It's rsynced.[2017-5-08. : 9:16 pm] Ashamed -- Mini Moose 2707Mini Moose 2707 shouted: sent 313378 bytes received 7934535503 bytes 1597031.07 bytes/sec total size is 8601307791 speedup is 1.08 real 82m48.433s ... the DLDB was significantly faster than expected, but there was a lot less CPU load this morning. I told you the db wouldn't take that long... but you really should of waited until the last step for db migration ><. Now you will have to do it again. and or miss data[2017-5-08. : 9:14 pm] Moose -- It'll continue making lots of small AJAX requests that will increase the load, yes.[2017-5-08. : 9:11 pm] Suicidal Insanity -- I wonder... if I keep 10 open tabs idling on SEN ... will the server explode?[2017-5-08. : 9:03 pm] Apos -- Mini Moose 2707Mini Moose 2707 shouted: Well, SC1 DLDB anyway. The SC2 one is a bit smaller. XD LOL[2017-5-08. : 8:54 pm] Moose -- sent 313378 bytes received 7934535503 bytes 1597031.07 bytes/sec total size is 8601307791 speedup is 1.08 real 82m48.433s ... the DLDB was significantly faster than expected, but there was a lot less CPU load this morning. |
Members Online: ihjel