Conversation
Notices
-
Guys over at LoadAverage are doing some pretty decent performance tooling some of which will probably find its way into !postActiv, fwiw. #postActiv
- lnxw37a1 repeated this.
-
@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. -
@xrevan86 This is why Ive been procrastinating with mysql optimizations, its such sweet sorrow xP
-
@maiyannah I can definitively say it's the slowest of them all excluding the search query though ;-).
-
@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.
-
@maiyannah I have it: https://paste.debian.net/hidden/4d11a11d (and it is applied on !loadaverage)!
And yes, this really does help with performance :-). -
@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.
-
@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 :-).
