Looks like HW fixed the index problem plaguing the site for the past 9 months, and guess that the cause was?
13:40:16 ~copypaste last night i turned off post stats before going to bed
13:40:20 ~copypaste that's why everything is zeroed
13:40:30 ~copypaste i found the reason for the original complaint [/v/ takes a long time to post to]
13:40:33 ~copypaste get ready for this
13:42:04 ~copypaste inserting into the board_stats table was taking many seconds
13:42:10 ~copypaste it was getting worse with more and more records
13:42:27 ~copypaste and because board_stats never prunes its historical record, combined with josh's inability to focus on database design
13:43:01 ~copypaste we all assumed that it was just the original reason i started the search for a new IB software, was making things worse
13:43:02 ~copypaste not so
13:43:31 ~copypaste not only did Josh fail at Next, but his incompetent post stats patch degraded preformance over time silently because josh sucks at DB design
13:43:33 ~copypaste what the fuck.
13:43:59 ~copypaste that's why things continued to get worse even with 8chan's user count decreasing
13:44:05 ~copypaste because the post stats table continued to grow
13:44:18 ~copypaste josh's insistence that algorithmic complexity did not apply to him was…wrong.
13:44:33 ~copypaste this is becoming shakesperean tragedy levels of sad.
13:44:35 maksev so basically
13:44:38 maksev hidden grenade
13:44:45 ~copypaste more like hidden balloon
13:44:46 maksev how fun i do so love db faults
13:44:56 ~copypaste or like hidden frog in slowly heating up water
13:45:01 Reveton josh is a moron. big O is hardly even computer science, it's just a basic understanding of how many operations you're doing
13:45:07 ~copypaste you've all noticed posting is better now with no stats right?
13:45:08 maksev picture a hentai where the girl is constantly force fed water up her ass until assplosion copypaste
——————————-
15:32:23 ranix wait did you just fix next by reverting one change
15:33:44 ranix oh you mean josh fucked up vichan
15:33:46 ranix well
15:34:08 ranix so he fucked up vichan and caused an emergency that required him to be hired as a full time coder to fix is
15:34:11 ranix it
15:34:13 ranix is that about the size of it
15:35:06 maksev yes
Full log here.
http://irclogs.8ch.net/rizon/%238chan-dev/2016-01-29