Suggestion page updates

Locked
User avatar
Corran
Joined: Mon Oct 14, 2002 7:40 pm
Contact:
Org Profile

Suggestion page updates

Post by Corran » Sun May 17, 2009 8:23 pm

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.

User avatar
Kariudo
Twilight prince
Joined: Fri Jul 15, 2005 11:08 pm
Status: 1924 bots banned and counting!
Location: Los taquitos unidos
Contact:
Org Profile

Re: Suggestion page updates

Post by Kariudo » Sun May 17, 2009 11:36 pm

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)
Image
Image

User avatar
Corran
Joined: Mon Oct 14, 2002 7:40 pm
Contact:
Org Profile

Re: Suggestion page updates

Post by Corran » Mon May 18, 2009 9:24 am

Kariudo wrote: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.

Locked

Return to “Site Announcements”