- [+]
- Community
- Sales Tracker
- Tools
- Counters
- Graphics
- Malls
- Guides
- Help/About
|
|
||
|
Fri, 06/08/2010 - 9:44pm
 Is there an easy way to see what date a counter was created? Is it possible to add a 'start date' to all counters? That's the basic question, and from there I could go crazy with more ideas nobody would want How much data is kept on the servers for the shop counters? The past week, like is displayed, and all data beyond a week old is purged? Since the counter and counter graph was never implemented in Portal, the online version seems the perfect place to do it, then Hits could be graphed along side sales and profits pretty easily (if you are going to have graphs eventually for the online version). I'll stop now, I really just cared about the date, and then I got going  mean tree, when did you add that #shoppers to the counter? Barnes & Neobles http://www.neopets.com/browseshop.phtml?owner=desperately_yours&misc  last night *using a proxy* -We're looking at at a SQL growth of roughly, 4000 entries per day, or 1.46 million per year. Figured that would cause some CPU issues with processing. Who knows.- I kinda figured that would be too much data, at least anything but the simple stats, but even that may be way too much too! Keeping the start dates shouldn't be bad though, it's only 1 entry per counter (of course, old counters would need an arbitrary date, if any). -mean tree, when did you add that #shoppers to the counter?- He added it last night, around 12:24AM saudor wrote:
last night You beat me to it again, but this time by 5 minutes at least (but again, after I'd started replying haha. And bleh. The new comments indicator isnt working anymore. I wonder why these things keep breaking like this First the error reporting tool went down. Fixed that, and now the comment thing is messed. bleh bleh bleh. Quote:
I wonder why these things keep breaking like this This should be an indication that you don't want an Unmanaged host I think this new host changed my configurations =/ And i think managing servers, i can learn on the fly But the security is still rock solid since i created it based on information provided on a hacking site Quote:
But the security is still rock solid since i created it based on information provided on a hacking site
now i know why the counter service kept crashing. Logic error. Should be fixed now i think. Ughh EDIT: ok there we go. Database isnt crashing itself now. Hope cron runs correctly too haha
|
vassarthepointe
Offline - Restock Banned Again 
Likes (0)
Male
Location: Toronto, ON
Rating: + 23
haha too late for that. Detailed stats are kept on the server for 2 days total. Simple stats (the counter total for that date) are deleted after 7 days.
But maybe it's possible to tweak it so the counter_history table doesnt get emptied. Either way, I'd have to modify the headers for it since it doesnt support it. And already with the current setup:
Showing rows 0 - 29 (16,062 total, Query took 0.0005 sec)
We're looking at at a SQL growth of roughly, 4000 entries per day, or 1.46 million per year. Figured that would cause some CPU issues with processing. Who knows.
-----------------------------
Contrary to popular belief, the Irish and I are not married