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: -1, Flamebait) by Anonymous Coward on Tuesday January 08 2019, @05:32PM (6 children)

    by Anonymous Coward on Tuesday January 08 2019, @05:32PM (#783755)

    Nosql is the clear answer. Group by clauses, set theory, and the relational model are for old white incels. Soylent should be hip and diverse and web-scale!

    Starting Score:    0  points
    Moderation   -1  
       Flamebait=1, Total=1
    Extra 'Flamebait' Modifier   0  

    Total Score:   -1  
  • (Score: 2) by Freeman on Tuesday January 08 2019, @06:08PM (5 children)

    by Freeman (732) on Tuesday January 08 2019, @06:08PM (#783775) Journal

    Oh, you mean, they should find some way to use an excel spreadsheet for all their database needs?

    --
    Joshua 1:9 "Be strong and of a good courage; be not afraid, neither be thou dismayed: for the Lord thy God is with thee"
    • (Score: 3, Funny) by khallow on Tuesday January 08 2019, @08:34PM (4 children)

      by khallow (3766) Subscriber Badge on Tuesday January 08 2019, @08:34PM (#783834) Journal
      If it's good enough for Eve Online, it's good enough for SoylentNews!
      • (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!

        • (Score: 2) by The Mighty Buzzard on Tuesday January 08 2019, @11:46PM (2 children)

          by The Mighty Buzzard (18) Subscriber Badge <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.
          • (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.
            • (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]