Stories
Slash Boxes
Comments

SoylentNews is people

posted by on Tuesday January 08 2019, @04:32PM   Printer-friendly
from the spit-and-baling-wire dept.

After a morning of slow query logging and cussing, a misplaced "GROUP BY" that was turning a 0.04 second query into one that took over fifteen seconds has been fixed. I'll leave the slow query log running overnight though just to make sure I didn't miss any less common ones. If you're still seeing any serious site slowdowns, let us know.

 
This discussion has been archived. No new comments can be posted.
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 2) by Runaway1956 on Wednesday January 09 2019, @03:19AM (1 child)

    by Runaway1956 (2926) Subscriber Badge on Wednesday January 09 2019, @03:19AM (#783964) Journal

    I've seen both of those. Type a reply, get called away by the wife, come back and hit submit. Or change to VPN, or disconnect from VPN. Both easily solved - hit the "back" button, copy what you had typed, then reload the topic to which you were responding, hit the "reply" button again. It's a mild irritant, might really piss some other people off.

    Starting Score:    1  point
    Karma-Bonus Modifier   +1  

    Total Score:   2  
  • (Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @04:27AM

    by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Wednesday January 09 2019, @04:27AM (#783979) Homepage Journal

    It'd probably be a good idea to ditch it for all registered users, honestly. If they get their spam on we have a damned easy recourse, so there's not really a need for them. Cleanup would still be annoying but not insurmountable.

    --
    My rights don't end where your fear begins.