Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: top 20 song hits

by CountZero (Bishop)
on Dec 01, 2013 at 16:49 UTC ( [id://1065156]=note: print w/replies, xml ) Need Help??


in reply to top 20 song hits

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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1065156]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2024-03-28 15:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found