Mostly done with my Pitch Day slides ... back to tuning WoT ... dumped the prod db to local so I can run modifcations of the algo on real data and see how it performs.
Discovered a couple of the servers at 50%+ memory today. 75th percentile of latency has been bad at ~300ms ... rotating in servers with more memory. After Bitcoin conf it'll be a decision between adding more features and speeding everything up. We'd get a huge speed up by doing a handful of things - most notably materializing otherwise slow queries also possibly switching some of the polling to websockets.
reply