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
  #31  
Old Jun 12, 2011, 05:31 AM
Cedille Cedille is offline
Trusted Editor
 
Join Date: Sep 2007
Location: Tokyo
Posts: 2,027
Default

And what's about sound engineers?
Reply With Quote
  #32  
Old Jun 12, 2011, 05:37 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

"Audio Engineer" -> Mix/Master/Recording Engineers.
Reply With Quote
  #33  
Old Jun 12, 2011, 05:54 AM
Cedille Cedille is offline
Trusted Editor
 
Join Date: Sep 2007
Location: Tokyo
Posts: 2,027
Default

I just added the person who is consistently credited as "Sound Engineer", so I wanted to know if there was a better way than just replacing him by somebody else.

On the other hand, subdividing performer credits is pretty nice. We currently can't even see what they perform at their discography pages, although I'm also concerned the list of "instrumentalist" will be super inflated, if we eventually have to add every instrument that has ever existed in the world.
Reply With Quote
  #34  
Old Jun 12, 2011, 06:18 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

Instruments will be denoted by a freetext field at first. That'll also save us the trouble of going through this entire list =)
Reply With Quote
  #35  
Old Jun 12, 2011, 08:46 PM
Revoc's Avatar
Revoc Revoc is offline
VGMdb Staff
 
Join Date: Dec 2007
Posts: 797
Default

Nice feature. And what's about conductors?
Reply With Quote
  #36  
Old Jun 12, 2011, 09:20 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

That would be a separate role, if we have a need for it.

By the way, it's "what about", not "what's about"...
Reply With Quote
  #37  
Old Jun 13, 2011, 12:57 PM
Revoc's Avatar
Revoc Revoc is offline
VGMdb Staff
 
Join Date: Dec 2007
Posts: 797
Default

Currently, we don't consider conductors as performers, like Cedille said here. Perhaps could be interesting a specific role. I suppose that conductors are close to the performance issue than other roles that are already available, such as mastering engineer.

Btw, what about producers?
Reply With Quote
  #38  
Old Jun 13, 2011, 03:46 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

It would be better if you guys compile a list of roles you want to see in the database =)

(And make it a separate thread for discussion)
Reply With Quote
  #39  
Old Jun 29, 2011, 08:38 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

June 29, 2011
  • Romaji tracklists now show "transliterated by" rather than "translated by"
Reply With Quote
  #40  
Old Nov 4, 2011, 06:49 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

November 4, 2011
  • Album table and viewcounter table converted to InnoDB, index added to product field; album pages should load much faster now


For a graphical representation of the effects:



The brown area is the average time spent on querying the albums table; the first dip at 07:29 is due to the switch to InnoDB, while the second (and most significant) dip at 07:43 is due to the added index.
Reply With Quote
  #41  
Old Nov 4, 2011, 07:21 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

It's interesting that inserting into vgmdb_track_albums spiked at each of those changes. It's still a potential looming problem as that table becomes gargantuan, but it seems under control for now.

These are some impressive speed gains.
Reply With Quote
  #42  
Old Nov 4, 2011, 08:39 AM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

Forgot to mention that I also changed the vgmdb_track_albums table into PARTITION BY LINEAR KEY based on albumid. Querying all views for a particular album should be blazing fast now.

By the way, if anyone's interested in the service I used to generate that performance graph, it's New Relic. Really easy to set up and use.
Reply With Quote
  #43  
Old Nov 4, 2011, 08:47 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

Seems like it could be a useful tool for performance tuning. For example, the result you posted may indicate that the query to the market wishlist table could be improved (perhaps it's not indexed ideally, or maybe there's something extra slowing it down -- I should take a look at that to satisfy my curiosity.)
Reply With Quote
  #44  
Old Nov 5, 2011, 07:17 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default



You can tell when I added an albumid index to the vgmdb_market_wish table (and a few other things too.)
Reply With Quote
  #45  
Old Nov 5, 2011, 09:20 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

While playing around with speeding up the code, I noticed that the code I wrote to put those little "pencil" icons up for the artist fields was very inefficient and required several calls to the modq database. I completely rewrote this and broadened the scope, so now the little pencil shows up in virtually every album data field. These only show up when a regular (non-staff, non-trusted) editor makes and edit to an album that for which he wasn't the submitter. This should make it easier to identify unapproved edits when glancing at an album page.
Reply With Quote
  #46  
Old Nov 9, 2011, 09:58 PM
Gigablah's Avatar
Gigablah Gigablah is offline
VGMdb Administrator
 
Join Date: May 2007
Posts: 2,397
Default

November 10, 2011
  • Price now shows "Free" rather than "Not For Sale" if an album is marked as "Event Only" with zero price.
Reply With Quote
  #47  
Old Mar 17, 2012, 05:03 AM
Secret Squirrel's Avatar
Secret Squirrel Secret Squirrel is offline
VGMdb Administrator
 
Join Date: May 2007
Location: Cleveland, OH
Posts: 5,934
Default

I didn't know the vBulletin calendar didn't go past 2011. Anyway, I've bumped it up a few years, so we can now add events for this year.
Reply With Quote
  #48  
Old Jun 4, 2012, 03:10 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 made a change to Org linking so that if an album doesn't fall between an Organizations start and end date (if specified), with a 1 year leeway in each direction, then that Org doesn't show up in the linker's list. This should prevent instances of hooking up the wrong label for labels who change names, and change back to the old name (Nippon Columbia, BMG, etc.)
Reply With Quote
  #49  
Old Aug 2, 2014, 09:16 PM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Staff
 
Join Date: Feb 2014
Location: Italy
Posts: 1,174
Default

There were a number of small changes over the past few weeks, here's a list:
  • The history pages are now using a proper diff engine that should make it a lot easier to see the exact changes. The "↩" symbol is used to denote added/removed newlines.
    Now it can also be accessed using the "Show History" link in the dropdown menu where all the other edit links are.
    If you didn't know about this kinda hidden feature, now is the time to go check what edits were made in the albums you previously submitted, and learn from them!
  • Twitter integration for artists is back. Remember that when you submit the twitter account name in the artist page, you should omit the @ at the beginning.
  • Added color coding to product search results.
  • The PM that gets sent when a new album/artist is rejected now contains its name, so users will be able to tell which one of their submissions got rejected in case they made more than one.
  • The maximum year for album release dates is now automatically updated.

If you notice any bug, especially with the new history, be sure report it in the bug reports thread.
__________________
Anime | Music | Stuff

Last edited by Illidan; Aug 4, 2014 at 11:21 PM.
Reply With Quote
  #50  
Old Aug 2, 2014, 11:45 PM
Dag's Avatar
Dag Dag is offline
VGMdb Staff
 
Join Date: Dec 2007
Posts: 1,279
Default

Plese let the arrow link come back, good sir (leave the edit menu link too).
Ancient conventions should be kept!
Reply With Quote
  #51  
Old Aug 3, 2014, 12:52 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Location: 5.342.482.337.666
Posts: 3,802
Default

I preferred the arrow link too, just use a different color for the arrow
also, illidan has access to the site? other staff too?
Reply With Quote
  #52  
Old Aug 3, 2014, 01:59 AM
Illidan's Avatar
Illidan Illidan is offline
VGMdb Staff
 
Join Date: Feb 2014
Location: Italy
Posts: 1,174
Default

Quote:
Originally Posted by Dag View Post
Plese let the arrow link come back, good sir (leave the edit menu link too).
Ancient conventions should be kept!
That was SS idea :P I don't see any issue in having both links (in fact, I found myself clicking the arrow several time today), so I suppose he can add it back.

@Phonograph: I don't actually have access to the server, I'm just helping a bit with these small things
__________________
Anime | Music | Stuff
Reply With Quote
  #53  
Old Aug 3, 2014, 02:30 AM
Phonograph's Avatar
Phonograph Phonograph is offline
Senior Member
 
Join Date: Jun 2010
Location: 5.342.482.337.666
Posts: 3,802
Default

I wondered because it's normally SS who speaks about that
Reply With Quote
  #54  
Old Aug 3, 2014, 05:54 AM
Myrkul's Avatar
Myrkul Myrkul is offline
VGMdb Staff
 
Join Date: Sep 2007
Location: France
Posts: 2,895
Default

I am also asking the return of the history link with the arrow
We'r all so used to that..
Reply With Quote
  #55  
Old Aug 3, 2014, 06:00 AM
Nisto's Avatar
Nisto Nisto is offline
VGMdb Staff
 
Join Date: Sep 2009
Posts: 1,156
Default

I agree. You don't have to remove the link from the Edit menu of course.
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