Conversation

Notices

1. Annah (maiyannah@community.highlandarrow.com)'s status on Tuesday, 23-Jan-2018 20:01:45 EST Annah
   Guys over at LoadAverage are doing some pretty decent performance tooling some of which will probably find its way into !postActiv, fwiw.  #postActiv
   1. Sorokin Alexei (xrevan86@loadaverage.org)'s status on Friday, 09-Feb-2018 19:10:13 EST Sorokin Alexei

      in reply to
      @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.
      1. Annah (maiyannah@community.highlandarrow.com)'s status on Friday, 09-Feb-2018 19:12:56 EST Annah

         in reply to
         @xrevan86 This is why Ive been procrastinating with mysql optimizations, its such sweet sorrow xP
         1. Sorokin Alexei (xrevan86@loadaverage.org)'s status on Friday, 09-Feb-2018 19:24:05 EST Sorokin Alexei

            in reply to
            @maiyannah I can definitively say it's the slowest of them all excluding the search query though ;-).
            1. Sorokin Alexei (xrevan86@loadaverage.org)'s status on Saturday, 10-Feb-2018 20:41:34 EST Sorokin Alexei

               in reply to
               @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.
      2. Sorokin Alexei (xrevan86@loadaverage.org)'s status on Thursday, 22-Mar-2018 13:40:54 EDT Sorokin Alexei

         in reply to
         @maiyannah I have it: https://paste.debian.net/hidden/4d11a11d (and it is applied on !loadaverage)!
         And yes, this really does help with performance :-).
         1. Sorokin Alexei (xrevan86@loadaverage.org)'s status on Thursday, 22-Mar-2018 13:45:14 EDT Sorokin Alexei

            in reply to
            @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.
         2. Sorokin Alexei (xrevan86@loadaverage.org)'s status on Thursday, 25-Apr-2019 14:41:02 EDT Sorokin Alexei

            in reply to
            @maiyannah Recently I've once again become disappointed with how this SQL query performs on !loadaverage, so I looked at it with a fresh eye, as a result https://notabug.org/diogo/gnu-social/commit/6b5450b7 was born.
            Must be good for postActiv as well :-).