SoylentNews

Meta: Site Performance

posted by on Tuesday January 08 2019, @04:32PM   
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.

• Re:I had just gotten used to it Re:I had just gotten used to it (Score: 0) by Anonymous Coward on Tuesday January 08 2019, @08:46PM (3 children)

  by Anonymous Coward on Tuesday January 08 2019, @08:46PM (#783843)

  CSV
  works for me!

  Parent

• Re:I had just gotten used to it Re:I had just gotten used to it (Score: 2) by The Mighty Buzzard on Tuesday January 08 2019, @11:46PM (2 children)

  by The Mighty Buzzard (18) <themightybuzzard@proton.me> on Tuesday January 08 2019, @11:46PM (#783889) Homepage Journal

  Let's try the lost art of compromise. CSV in an Excel spreadsheet. Best to be on the safe side and encapsulate it in XML too.

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

  Parent

  • Re:I had just gotten used to it Re:I had just gotten used to it (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.

    Parent

    • Re:I had just gotten used to it (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]

      Parent