Just another Perl shrine | |
PerlMonks |
Re: top 20 song hitsby CountZero (Bishop) |
on Dec 01, 2013 at 16:49 UTC ( [id://1065156]=note: print w/replies, xml ) | Need Help?? |
Keep the scores in a database and use standard SQL to get the info out. Database engines do that all the time and are highly optimized to do it well, fast and correct. Actually I have a Logitech Slimserver / Squeezeserver (or whatever is its present name). Everytime I play a song and don't fast-forward it to the next one, the server increases that song's "popularity". If I want to listen to the "most popular songs" or even "most popular songs not recently played" (or any other combination of parameters attached to each song), the server goes out to the database and finds them by using some standard SQL. CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James My blog: Imperial Deltronics
In Section
Seekers of Perl Wisdom
|
|