Unterhaltung

Nachrichten

1. xrevan86 Load Average resources , maiyannah

   @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 …

   Saturday, 10-Feb-18 00:10:13 UTC von loadaverage.org
   • drak gefällt das.
   • drak wiederholte dies.
   • xrevan86 Load Average resources , maiyannah

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

     Thursday, 22-Mar-18 17:40:54 UTC
   • xrevan86 maiyannah

     @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.

     Thursday, 22-Mar-18 17:45:14 UTC
   • xrevan86 Load Average resources , maiyannah

     @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 :-).

     Thursday, 25-Apr-19 18:41:02 UTC