Hello all!
Recently I've been implementing new index types inside of the xonstatdb database, which is the datastore that powers XonStat. I've just completed work in XonStat to make use of those indexes, resulting in dramatically faster page-loads on several pages. Most of you will notice the snappiness in the "player info" and "player recent games" pages.
How fast? Gee, I thought you'd never ask! I ran Apache Bench tests on my laptop to find out.
Original, unmodified requests to a player's page:
Time per request: 5883.632 [ms] (mean)
Time per request: 1176.726 [ms] (mean, across all concurrent requests)
Requests of the same pages using the new index types:
Time per request: 181.307 [ms] (mean)
Time per request: 36.261 [ms] (mean, across all concurrent requests)
That's more than a 30x increase. Woohoo! Enjoy it folks, and happy holidays to everyone!
asyyy^ | are you releated to chuck norris?