FistyDollars Posted May 3, 2016 Author Posted May 3, 2016 So I've been having issues in the moderation queue in the past week. Initially it seemed like it was taking longer and longer to generate a new entry to moderate (20-30 second wait at times, from 3-5 in the beginning.) Now when I go to moderate, I frequently will get errors such as the one I took a screengrab of. I even tried multiple browsers. Is anyone else getting these issues?
Jason Carr Posted May 3, 2016 Posted May 3, 2016 Thanks @FistyDollars, I didn't know this was happening. I'll review.
Jason Carr Posted May 4, 2016 Posted May 4, 2016 Hey guys, some questions. When that error comes up, how long are you having to wait for the page to load? Are you able to resume moderating if you refresh the page or are you guys all dead in the water?
Jason Carr Posted May 4, 2016 Posted May 4, 2016 Sorry, I see the "20-30 second wait times". Still wondering, though, does it work eventually or are you stuck?
Jason Carr Posted May 4, 2016 Posted May 4, 2016 I'm guessing I just have some optimization I need to do. Looks like it might be getting slower as you moderate more and more records. On it.
Jason Carr Posted May 4, 2016 Posted May 4, 2016 Well, it seems to be getting better, but I'm still not happy with the performance. I got it down to 10 seconds so far. Anyone still seeing error messages?
FistyDollars Posted May 4, 2016 Author Posted May 4, 2016 I'm getting about 11-12 seconds consistently as of right now, so that's way better. No error messages so far, which is good because by around 3-4 pm PST today I'd have to reload the page once or twice just to get a new entry and not an error message. I'll update if anything changes.
Jason Carr Posted May 4, 2016 Posted May 4, 2016 Thanks @FistyDollars, hoping I have this pretty well optimized now. It's loading in a second or two for me. :)
FistyDollars Posted May 4, 2016 Author Posted May 4, 2016 Yup, I just started up again, and it is BLAZINGLY fast. Love it!
Cebion Posted May 4, 2016 Posted May 4, 2016 FistyDollars said Yup, I just started up again, and it is BLAZINGLY fast. Love it! Thats just plain crazy how fast the moderation now is. I waited almost half a minute or so to load the next game. Now it's almost instant! Thanks @jason
Jason Carr Posted May 4, 2016 Posted May 4, 2016 Hehehe, thanks guys. It's amazing how much a little optimized SQL can fix things up. :)
Vlansix Posted September 17, 2017 Posted September 17, 2017 Internal Server Carnage resolved. Closing ticket.
Recommended Posts