VGMdb
Go Back   VGMdb Forums > VGMdb Site Related > Questions and Comments
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old Mar 29, 2008, 01:04 PM
Liontamer's Avatar
Liontamer Liontamer is offline
VGMdb Staff
VGM Artist
 
Join Date: Sep 2007
Location: Atlanta, GA
Posts: 419
Default Re: Top Album Statistics

Any chance we can add the functionality for the Top Album Statistics to not just display aggregated stats, but also filtering for each album category (i.e. Official Release, Enclosure / Promo, Doujin, Works, Game Animation & Film, Demo Scene, Bootleg, Other). Would be cool to see breakdowns on the other categories without Official Releases getting in the way.
__________________
Larry "Liontamer" Oji
Community Manager & Submissions Judge, OverClocked ReMix
OC ReMix ~ twitter.com/ocremix ~ facebook.com/ocremix ~ youtube.com/ocremix
Reply With Quote
  #2  
Old Mar 29, 2008, 07:58 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

I could come up with all kinds of stats, but I mostly tried to stick with a small manageable set of useful statistics. What you mentioned sounds interesting though. Perhaps I should think about a way to generate user-customizable stats and top lists.
Reply With Quote
  #3  
Old Mar 30, 2008, 04:54 AM
seanne's Avatar
seanne seanne is offline
VGMdb Staff
 
Join Date: May 2007
Location: Sweden
Posts: 1,202
Default

I too would definitely like to see more in-depth stats made available on the stats page. What Liontamer mentioned would be neat, as would longer lists of the different stats already available (e.g a "more" link could be added).
__________________
VGMdb group on last.fm
Reply With Quote
  #4  
Old Mar 30, 2008, 06:27 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

So what else would everyone like to see besides Classification filtering and the capability to browse the full top lists?

I was thinking of adding some more primary or secondary stats such as label count and weblink count, as well as a few more submission statistics. Also, the top and bottom rated artists would be interesting to look at, particularly since it's a derived stat.
Reply With Quote
  #5  
Old Apr 4, 2008, 05:25 PM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

I've added paginated browsing to all the lists (which ended up being a lot more of a pain than I thought.) The only thing that I'm dissatisfied about is that the 30-day window album views is a bit slow to load (1.34 sec), but that's because it's got to count a couple hundred thousand views instead of 20. Maybe there's a clever way to fix that.

I'll be thinking about the classifications next, and about adding more stats (possibly expanding to 2 or 3 pages.)
Reply With Quote
  #6  
Old Apr 8, 2008, 03:31 AM
seanne's Avatar
seanne seanne is offline
VGMdb Staff
 
Join Date: May 2007
Location: Sweden
Posts: 1,202
Default

For some reason the entry id numbers are left out of the links on the " Most Frequently Viewed Albums (Last 30 Days)" list now, SS.
__________________
VGMdb group on last.fm
Reply With Quote
  #7  
Old Apr 8, 2008, 03:34 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

Oops, sorry about that. I was playing around with ways to try to speed up that query. The links work now.
Reply With Quote
  #8  
Old Apr 8, 2008, 04:46 AM
seanne's Avatar
seanne seanne is offline
VGMdb Staff
 
Join Date: May 2007
Location: Sweden
Posts: 1,202
Default

Would increasing the number of entries on each list be worthwhile as far as search times are concerned? Perhaps top-100, top-150 instead of top-20? It would limit some people to perhaps only one search instead of 5-6, and at the same time giving them a better view of the top-100, or whatever they might be interested in.
__________________
VGMdb group on last.fm
Reply With Quote
  #9  
Old Apr 8, 2008, 04:53 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

In general, if it means the user loads less pages, then yes since the slow part is counting the view table, not adding the album info afterwards. To be honest, I really don't know how everyone else uses these. If we went with top 100, do we even need the pagination?
Reply With Quote
  #10  
Old Apr 9, 2008, 07:35 AM
seanne's Avatar
seanne seanne is offline
VGMdb Staff
 
Join Date: May 2007
Location: Sweden
Posts: 1,202
Default

I reckon most people would be content with a limited number, like 100. Anyone else got any thoughts on this?
__________________
VGMdb group on last.fm
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Oops] How to change new album to child album? Rew Questions and Comments 2 Feb 21, 2015 09:13 AM
Submissions - Album Titles - Poll - Choose a Title for This Album Secret Squirrel Submission Guideline Restructuring 31 Apr 26, 2010 01:57 AM