Suggestion page updates

This forum is for site announcements. Please go here to read the SITE & FORUM RULES.

Suggestion page updates

Postby 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
Corran
 
Joined: 14 Oct 2002

Re: Suggestion page updates

Postby 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)
ImageImage
Image
User avatar
Kariudo
Twilight prince
 
Joined: 15 Jul 2005
Location: Los taquitos unidos
Status: 1924 bots banned and counting!

Re: Suggestion page updates

Postby 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.
User avatar
Corran
 
Joined: 14 Oct 2002


Return to Site Announcements

Who is online

Users browsing this forum: No registered users and 1 guest