|
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-2-21. : 8:48 am] wijeoa -- To Administrator: I want to delete http://www.staredit.net/sc1db/file/3609/ because it redundants[2017-2-21. : 6:09 am] NudeRaider -- The only time where you'd see any relevant impact between 1,000 and 10,000 rows is when you join it with something big, like a 400k posts table. And if for whatever reason you do that on a regular basis (or more like all the time) your design sucks, not the table.[2017-2-21. : 5:44 am] NudeRaider -- not sure why you guys are so fixated on member counts like it'd be the magic cure. Let me tell you, it's not. How many members do we have? 10,000 ? That's a laughably low number of rows for any db engine really.[2017-2-21. : 5:25 am] lil-Inferno -- tbh fam, just run this query in the DB: DELETE FROM users user WHERE CURRENT_TIMESTAMP > user.last_active + (interval '1 millisecond' * 63113904000);[2017-2-21. : 4:50 am] NudeRaider -- sometimes I wish I could just restart or take down our demon. Or even better: reconfigure it.[2017-2-21. : 4:48 am] NudeRaider -- Mini Moose 2707Mini Moose 2707 shouted: Like, my meme fucking around is already way past what should even be done in production, laughing my ass off reminds me of when our proxy servers were acting up. We started giving great care not to create downtimes, by securely taking down 1 at a time rerouting through the others. This created so many problems that we ended up having them all up and running and just implementing the necessary changes live and doing live deamon restarts. Sometimes there comes a point where a man just has to say "fuck it". ![]() ![]() [2017-2-21. : 4:44 am] NudeRaider -- Mini Moose 2707Mini Moose 2707 shouted: problems with the whole site TBH you Sir, just got trolled: VraelVrael shouted: anyone else havaing problems with spambox? [2017-2-21. : 4:08 am] O)FaRTy1billion[MM] -- ignore the stuff later, I was too lazy to find just the quote I wanted[2017-2-21. : 4:06 am] Moose -- Like, my meme fucking around is already way past what should even be done in production, laughing my ass off ![]() [2017-2-21. : 4:04 am] Moose -- Still need to make a development server or subserver. Which I think Devourer may have done, idk.[2017-2-21. : 4:03 am] O)FaRTy1billion[MM] -- lol when I had access it was just directly to the code that was used xD[2017-2-21. : 4:02 am] Moose -- Sure. I mean, anything you guys touch would be going to a development copy before it's pushed to production anyway.[2017-2-21. : 4:00 am] Moose -- I mean, it would be nice if Devourer or DevliN were actually around LMAO[2017-2-21. : 3:57 am] Dem0n -- Spends an entire day accomplishing nothing when he could have like 3 other people help him and solve it quickly LMAO[2017-2-21. : 3:56 am] Corbo -- jjf28jjf28 shouted: gimme SEN access, I'll get this place searchable =) I'll settle for usable.[2017-2-21. : 3:54 am] Dem0n -- CorboCorbo shouted: the search isn't even useful, like the results are all messed up, poorly displayed and... rankly it's missing stuff. It's not even a propersearch, we cannot find topics by poster, id, keywords or anything an actual real forum search has That's an epic I was thinking of[2017-2-21. : 3:53 am] Corbo -- the search isn't even useful, like the results are all messed up, poorly displayed and... rankly it's missing stuff. It's not even a propersearch, we cannot find topics by poster, id, keywords or anything an actual real forum search has[2017-2-21. : 3:53 am] Dem0n -- jjf28jjf28 shouted: Corbo I wrote an app to search all fields of some 200k cell sites in under 2 seconds; member list should be fine But you had good code to go along with it. The rest of SEN doesn't work LAMO[2017-2-21. : 3:53 am] Moose -- Dem0nDem0n shouted: lmao the most inactive accounts have a "Last Active" value of December 31, 1969 UNIX Epoch imo[2017-2-21. : 3:53 am] Dem0n -- lmao the most inactive accounts have a "Last Active" value of December 31, 1969[2017-2-21. : 3:53 am] jjf28 -- CorboCorbo shouted: like, SEN has like 9k+ accounts and if someone clicks and sorts the memberlist it has to go through all the DB. I wrote an app to search all fields of some 200k cell sites in under 2 seconds; member list should be fine[2017-2-21. : 3:53 am] Moose -- Well, the issue here was the sessions table has 100K+ rows and was using the MyISAM instead of InnoDB engine. The former of which uses table-level locking. Even though the thing is inserted to or updated with every page load.[2017-2-21. : 3:52 am] Dem0n -- should just be an auto-task that runs at like midnight every night to bop inactive accounts[2017-2-21. : 3:51 am] Corbo -- like, SEN has like 9k+ accounts and if someone clicks and sorts the memberlist it has to go through all the DB.[2017-2-21. : 3:51 am] Dem0n -- Moose are you sure SEN isn't using some SQL shit in like 2000 compatibility or something? There's an issue at my job where we're using SQL Studio 2005 in 2000 compatibility and it's causing some characters to show up as <?> symbols because it's trying to encode/decode them using some like Windows 98 charset or something LMAO[2017-2-21. : 3:51 am] Corbo -- You know, I truly believe it's BS like member list that make the site slower[2017-2-21. : 3:50 am] jjf28 -- CorboCorbo shouted: Do not touch anything more. We don't care about the forums anyway LMAO don't forget we need boxes and a member list to tell us how rich people are ![]() [2017-2-21. : 3:50 am] Corbo -- and I'm like OSHIT WHERE ARE THEY and then realise they have their own button xD[2017-2-21. : 3:49 am] Corbo -- actually, many times I find myself looking for the "forums" option under site submenu |
Moose