#31
|
|||
|
|||
And what's about sound engineers?
|
#32
|
||||
|
||||
"Audio Engineer" -> Mix/Master/Recording Engineers.
|
#33
|
|||
|
|||
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. |
#34
|
||||
|
||||
Instruments will be denoted by a freetext field at first. That'll also save us the trouble of going through this entire list =)
|
#35
|
||||
|
||||
Nice feature. And what's about conductors?
|
#36
|
||||
|
||||
That would be a separate role, if we have a need for it.
By the way, it's "what about", not "what's about"... |
#37
|
||||
|
||||
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? |
#38
|
||||
|
||||
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) |
#39
|
||||
|
||||
June 29, 2011
|
#40
|
||||
|
||||
November 4, 2011
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. |
#41
|
||||
|
||||
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. |
#42
|
||||
|
||||
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. |
#43
|
||||
|
||||
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.)
|
#44
|
||||
|
||||
You can tell when I added an albumid index to the vgmdb_market_wish table (and a few other things too.) |
#45
|
||||
|
||||
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.
|
#46
|
||||
|
||||
November 10, 2011
|
#47
|
||||
|
||||
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.
|
#48
|
||||
|
||||
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.)
|
#49
|
||||
|
||||
There were a number of small changes over the past few weeks, here's a list:
If you notice any bug, especially with the new history, be sure report it in the bug reports thread. Last edited by Illidan; Aug 4, 2014 at 11:21 PM. |
#50
|
||||
|
||||
Plese let the arrow link come back, good sir (leave the edit menu link too).
Ancient conventions should be kept! |
#51
|
||||
|
||||
I preferred the arrow link too, just use a different color for the arrow
also, illidan has access to the site? other staff too? |
#52
|
||||
|
||||
Quote:
@Phonograph: I don't actually have access to the server, I'm just helping a bit with these small things |
#53
|
||||
|
||||
I wondered because it's normally SS who speaks about that
|
#54
|
||||
|
||||
I am also asking the return of the history link with the arrow
We'r all so used to that.. |
#55
|
||||
|
||||
I agree. You don't have to remove the link from the Edit menu of course.
|
#56
|
||||
|
||||
Haven't used this thread for ages, but here are some recent changes.
New Platforms: Pachislot Machine, Pachinko Machine, Tabletop New New Artist Role: Scriptwriter New Media Type: Download Card Album Classifications:
Product Classifications:
Content filtering added to the Artist and Calendar pages. 2 changes to improve moderation queue activities. |
#57
|
||||
|
||||
Added a new forum for albums under Miscellaneous Discussion. Now:
Video Game Music Discussion/Album Discussions <-- All albums categorized as Game. Anime Music Discussion/Album Discussions <-- All albums categorized as Animation (unless they are also in Game.) Miscellaneous Discussion/Album Discussions <-- All albums that are not classified as Anime or Game. |
#58
|
||||
|
||||
Modified the database queries for displaying the most recently updated albums, media, and ratings. The pages load much faster now (instant vs 15 seconds for worst cases), though the results are limited to the last 3 months (which should be no problem.)
|
#59
|
||||
|
||||
If you're having any issue, please post here. |
#60
|
||||
|
||||
|
Thread Tools | Search this Thread |
Display Modes | |
|
|