|
Re: Speeding up the site
Originally Posted by StarTracker
I run the StarTracker website and I found this thread from February. This is the first discussion I have found where people actually understood what the stats meant on the site.
The site has gradually gotten slower and slower as more data is captured. I have optimized the database as much as I can but my server just can't query fast enough.
I was thinking of only keeping the last 6 months of detailed results in the database, and then archiving the data in summary form for the older months. I was thinking of keeping: n played, average buyin, average number of players, itm, afp, aroi, and roi for each month. Breaking it down further by size of tournament and buyin seemed like overkill.
Any thoughts?
First I love star tracker. I find that hud stats are worth much less in sngs and small tourneys than profitability stats. When I am at a tough decision early in a game I will often consult tracker stats.
Archiving can be a monstrous task but is economical in terms of not needing hardware upgrades. I would see if there's a way to get a survey out to your user base and propose what the summary would look like, then determine whether it is something that will piss people off or whether people will appreciate it. If you ask the right questions you could also get design feedback this way and potentially make the UI better.
I for one think summary data is a good way to go if you have the manpower to take it on. I trust newer data obviously over older data.
One thing about the current UI is the "last 20 played" seems way too small and I pretty much ignore it because of the huge variance involved in the games. Yet it is displayed so prominently. I would say something more along last 100 or 200. Still a small sample size but it gets to the spirit of what I think you are intending that display for (how have things been going for them "recently"). I still pretty much discount that stat anyway.
|