Managing a Huge Music Collection?

subkid asks: "I've tried several different solutions to manage my music collection; iTunes, WinAmp playlists, visual MP3, and so forth. but none satisfy my idea of what I want. I have many thousand files and things are getting a bit out of hand. I like the functionality of iTunes but not the memory it uses. WinAmp uses less but makes finding the song I want is even harder. Things like musicbrainz.org help for making sure the songs are tagged properly but is there an all-in-one solution? How do you manage your large collection?"