Suggestion page updates

[Corran]

As more and more people gave star ratings to videos, the star rating suggestion tool became slower and slower. For users that had rated thousands of videos, this became even more of a problem. There was also a problem with the page not properly limiting its calculations to once per day per method, so if you clicked refresh or later returned to the page, the entire, time-consuming calculation would be repeated.

If these problems have caused you to avoid using this page, I''d like to tell you we've made improvements to make it usable again.

The calculation's database queries have been optimized and it only looks at the last 300 star ratings you've giving now. Aside from speeding up the calculation, you may find it more accurate as people's tastes tend to change over time anyways. The calculation is still intensive so it will take about 20 seconds or so to run if you have 300+ ratings. (Previously it was taking about 60+ seconds...) The suggestions page now properly only runs its calculation once per day per method. Also, the results will now display whether or not the video can be previewed.

[Kariudo]

huh, we had such a tool?

...so that's what suggestion query is

maybe it could be further optimized if the calculations were done only after you've given a new rating (if that frequency is greater than 1 day, else update once for that day if more than 1 rating has been given)

[Corran]

maybe it could be further optimized if the calculations were done only after you've given a new rating (if that frequency is greater than 1 day, else update once for that day if more than 1 rating has been given)

If the calculation was only affected by the star ratings you gave that could work, but it is affected by the star ratings of all users that give similar ratings. You don't have to rate videos to get different results on a different day.