|
song searching should be improved
|
| I think that it would be a good idea to add new column in Download section - number of votes. Number of clicks doesn't tell us if whenever song is popular or not. Neither does ranking. |
|
Re: song searching should be improved
Link |
by
on 2006-02-07 01:54:20 |
Well, it can be possible. I like that suggestion. But it depends on Gendou's decision....  Cardcaptor Sakura: Blooming Days!: Dreams and Fantasies Becomes A Reality |
|
Re: song searching should be improved
Link |
by hakuryu-kun
on 2006-02-07 05:22:34
|
|
It depends on Gendou's decision!
VICTORY goes to the only one who is the bravest!
If you are not brave, you will lose but you still have the courage in your heart!--> |
|
Re: song searching should be improved
Link |
by
on 2006-02-07 07:13:42 |
|
If you click on the vote link next to the rating it tells you how many votes have been cast on that song. It would be nice to have that on the main download page though. |
|
Re: song searching should be improved
|
|
It's possibble to view number of votes for each song. The only problem is that it's not to comfortable and you can't find song witch highest ranking. Unless you do that for every song. Should I send an e-mail to gendou to ask him? |
|
Re: song searching should be improved
Link |
by
on 2006-02-07 20:12:16 |
|
I hear your request but doubt it would be an improvement of any sort. As you can see by the below query, the standard deviation of the ratio of download count to number of ratings is nearly one. This means that a song downloaded twice as often than the average will likely receive between 1.5 and 2.5 as many votes than average. This makes an additional column statistically obsolete. SELECT STDDEV(stddlcount/stdvcount)
FROM (
SELECT dlcount/6109.2649 AS stddlcount, COUNT(*)/9.3673 AS stdvcount
FROM Amusic
JOIN Rate USING (id)
WHERE online = 1
GROUP BY Amusic.id
) AS Results;
+------------------------------+
| STDDEV(stddlcount/stdvcount) |
+------------------------------+
| 1.192934264350 |
+------------------------------+
1 row in set (0.26 sec) 
|