Site Database Changes

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

Site Database Changes

Postby Phade » Sun Apr 25, 2004 11:22 pm

Hey,

Some site database manipulations have gone through. The star_count, star_avg, local_download_count, and opinion_count have been relocated internally. If you see anything wierd happen where these should show up (searches, video info, lists, etc), please let me know. Hopefully this should help with query cache performance and help get rid of a deadlock situation that pops up during really heavy usage times.

Phade.
User avatar
Phade
Site Admin
 
Joined: 20 Oct 2000
Location: Little cabin in the woods...

Postby CaTaClYsM » Mon Apr 26, 2004 10:36 am

k
So in other words, one part of the community is waging war on another part of the community because they take their community seriously enough to want to do so. Then they tell the powerless side to get over the loss cause it's just an online community. I'm glad people make so much sense." -- Tab
User avatar
CaTaClYsM
 
Joined: 26 Jul 2002

Postby ReannaKing » Mon Apr 26, 2004 6:07 pm

Star ratings aren't showing up for the videos I recently uploaded. Did I miss an announcement about that?
User avatar
ReannaKing
 
Joined: 20 Sep 2001
Location: Eau Claire, Wisconsin

Postby Phade » Mon Apr 26, 2004 8:53 pm

Hey,

Bug detected and squashed. The next time someone enters a star rating, the stats will update.

Phade.
User avatar
Phade
Site Admin
 
Joined: 20 Oct 2000
Location: Little cabin in the woods...

Postby Phade » Mon Apr 26, 2004 10:06 pm

Hey,

Nevermind. I ran a script to update all counts and scores. They should all be correct now.

Phade.
User avatar
Phade
Site Admin
 
Joined: 20 Oct 2000
Location: Little cabin in the woods...

Postby ReannaKing » Mon Apr 26, 2004 10:18 pm

Thanks Phade. :)
User avatar
ReannaKing
 
Joined: 20 Sep 2001
Location: Eau Claire, Wisconsin


Return to Site Announcements

Who is online

Users browsing this forum: No registered users and 1 guest