I can see there are some advantages, though I don't think we ever Left Join the username table with the album/tracklist/scans tables. We potentially could when we do the stats page, but my thoughts for that are to limit it to the top 10 names for each stat, so we'd end up making 10 queries in a loop to the Username table instead.
Also, people change their usernames (though we could disallow it.)
I'll admit that renumbering userids was a pain. I did it manually for collections, where there wasn't a username field, so I had to look up userIDs on Gamingforce.
|