All right. So I have been writing about my WallRush.com project.

I am currently modifying the sql that retrieves content. As declared I want the content to be relevant for me (the user). To do this I have normalized personal popularity and age of the content and then weighted these when sorting for relevance. This won't suffice, I will have to include people of similar tastes evaluation of the content in the weighting before its good, but it still manages to retrieve the 3 videos in the base that I think is coolest right now :)

It will be fun to see how the SQL server will act if there are many request, since the SQL is not exactly "ressource friendly".