|
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: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.[2017-5-08. : 7:15 pm] lil-Inferno -- Dem0nDem0n shouted: lil-Inferno If the trigger isn't owned by all players that need a unit created, this won't work, which is what I was getting at Then make it owned by all the players LMAO[2017-5-08. : 7:05 pm] NudeRaider -- Pyro682Pyro682 shouted: Also, I have just reviewed my 'latest' activity with SEN, and I remember my dream test map, "Spell Generator" wasn't released, NOR finished. I think I will see what I can grab from my notes and piece it together once more. I did, after all, say this will be the last thing I do on SC! then maybe you should keep it lying there for a bit longer and do other things for now [2017-5-08. : 6:36 pm] Dem0n -- lil-Infernolil-Inferno shouted: Can't you just do one trigger for those 6 players and use current player? There's no reason to ever have the same trigger for multiple players if you know what you're doing. If the trigger isn't owned by all players that need a unit created, this won't work, which is what I was getting at[2017-5-08. : 6:30 pm] Pyro682 -- Also, I have just reviewed my 'latest' activity with SEN, and I remember my dream test map, "Spell Generator" wasn't released, NOR finished. I think I will see what I can grab from my notes and piece it together once more. I did, after all, say this will be the last thing I do on SC![2017-5-08. : 6:30 pm] m.0.n.3.y -- lil-Infernolil-Inferno shouted: Can't you just do one trigger for those 6 players and use current player? There's no reason to ever have the same trigger for multiple players if you know what you're doing. that's what I thouhght, but idk i'm trying to do something really simple but it's taking so long for some reason lol....[2017-5-08. : 6:29 pm] m.0.n.3.y -- Wait, if "current player" is owned by a computer, and I set that players death counter to 1, and then say --> when current player (the computer) death count is one create a zergling... will it create a zergling or not because "curren't player" is a computer?[2017-5-08. : 6:27 pm] lil-Inferno -- Can't you just do one trigger for those 6 players and use current player? There's no reason to ever have the same trigger for multiple players if you know what you're doing.[2017-5-08. : 6:12 pm] Pyro682 -- Dem0ns will work as well, but it's more work for the same result, and it takes away a Unit Death. AKA He sucks and I'm fuckin pwnage[2017-5-08. : 6:09 pm] Pyro682 -- Instead of 1 trigger creating 1 ling for each player, you can have 6 isolated triggers that all use the 'current player' value for the given key index of player ownership[2017-5-08. : 6:08 pm] Dem0n -- I would advise against ever spawning units for multiple players in the same trigger. If you need to do that, just set a death for each player in that group trigger, and then make individual triggers for each player saying if they have a death of that unit, then create a zergling[2017-5-08. : 6:07 pm] m.0.n.3.y -- Dem0nDem0n shouted: you can put the trigger under player 2 and it won't run if he's not in game what about if there's like 6 players? |
Members Online: lifebot