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 Pino P on Wednesday January 09 2019, @02:15PM (1 child)

    by Pino P (4721) on Wednesday January 09 2019, @02:15PM (#784104) Journal

    If I'm commenting while riding the city bus, then my IP address will change depending on what hotspots my laptop or phone happens to pick up at the time. Could the form key IP address check be made less stringent for logged-in users, or for excellent-karma logged-in users? Or is it considered a measure against account compromise?

    Starting Score:    1  point
    Karma-Bonus Modifier   +1  

    Total Score:   2  
  • (Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @02:21PM

    by The Mighty Buzzard (18) Subscriber Badge <themightybuzzard@proton.me> on Wednesday January 09 2019, @02:21PM (#784106) Homepage Journal

    It could likely be removed entirely for registered users. I'll need some thought time on the ramifications.

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