Conversation

Notices

  1. Guys over at LoadAverage are doing some pretty decent performance tooling some of which will probably find its way into !postActiv, fwiw.  #

    about 7 months ago from community.highlandarrow.com
    1. @maiyannah In the end I don't think I succeeded in my attempts at optimising the SELECT at lib/inboxnoticestream.php.
      But on !loadaverage another thing actually did get a good result: the Compressed raw format on the "notice" table.
      Seems counter-intuitive that compression improves performance but, on the other hand, that makes the amount of data simultaneously in RAM a lot larger, so here we are.

      about 6 months ago from loadaverage.org
      1. @xrevan86 This is why Ive been procrastinating with mysql optimizations, its such sweet sorrow xP

        about 6 months ago from community.highlandarrow.com
        1. @maiyannah I can definitively say it's the slowest of them all excluding the search query though ;-).

          about 6 months ago from loadaverage.org
          1. @maiyannah Turns out search queries are fixable: fulltext indices are supported in InnoDB with MariaDB 10.0+, and I've enabled it on loadaverage.org just now.

            about 6 months ago from loadaverage.org
      2. @maiyannah I have it: https://paste.debian.net/hidden/4d11a11d (and it is applied on !loadaverage)!
        And yes, this really does help with performance :-).

        about 5 months ago from loadaverage.org
        1. @maiyannah As a downside, the generated queries can be extremely long (like 40 000 symbols), yet, for some reason, that works significantly better than what was before still.

          about 5 months ago from loadaverage.org