Stories
Slash Boxes
Comments

SoylentNews is people

Meta: Site Performance

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

The Mighty Buzzard writes:

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.
Meta: Site Performance | Log In/Create an Account | Top | 42 comments | Search Discussion
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: 4, Funny) by maxwell demon on Wednesday January 09 2019, @06:45AM (1 child)

    by maxwell demon (1608) on Wednesday January 09 2019, @06:45AM (#784007) Journal

    But only if the XML is encapsulated in JSON.

    --
    The Tao of math: The numbers you can count are not the real numbers.
    Starting Score:    1  point
    Moderation   +2  
       Funny=1, Touché=1, Total=2
    Extra 'Funny' Modifier   0  
    Karma-Bonus Modifier   +1  
    Total Score:   4  

  • (Score: 0) by Anonymous Coward on Wednesday January 09 2019, @11:02AM

    by Anonymous Coward on Wednesday January 09 2019, @11:02AM (#784050)

    Fine, so long as you then serialize it with YAML [wikipedia.org]