Remove Ad, Sign Up
Register to Remove Ad
Register to Remove Ad
Remove Ad, Sign Up
Register to Remove Ad
Register to Remove Ad
Signup for Free!
-More Features-
-Far Less Ads-
About   Users   Help
Users & Guests Online
On Page: 1
Directory: 1 & 140
Entire Site: 5 & 986
Page Staff: pennylessz, pokemon x, Barathemos, tgags123, alexanyways, supercool22, RavusRat,
04-19-24 09:38 AM

Thread Information

Views
591
Replies
3
Rating
4
Status
CLOSED
Thread
Creator
Davideo7
03-12-17 08:31 AM
Last
Post
Cyro Xero
03-13-17 06:07 PM
Additional Thread Details
Views: 372
Today: 0
Users: 49 unique

Thread Actions

Thread Closed
Order
 

New 'Best' Formula + Site Optimized Again

 

03-12-17 08:31 AM
Davideo7 is Online
| ID: 1332267 | 444 Words

Davideo7
Level: 351


POSTS: 41417/45320
POST EXP: 3474068
LVL EXP: 811430859
CP: 191263.8
VIZ: 121500527

Likes: 4  Dislikes: 0
New 'Best' Formula
The old formula for ordering the games based on 'Best' was votes * rating. The new formula is:
(rating-5)*(votes/10)
You can see the results of the new order here:
https://www.vizzed.com/p/?sort=best
It's pretty similar on the first few pages but further pages it changes up a bit. I think this orders things better because there were some average rated games that had a lot of votes that were being ranked high and now this pushes them further down. Having the rating - 5 (where max rating is 10) makes any rating above a 5 considered a positive rating and any rating below a 5 a negative rating which places more emphasis on positive scores (before a bad score would have still been given weight).

The reason having things order by just rating isn't good enough is because a game could have just a few votes where the users all voted the game a 10 but that doesn't mean the game deserves that high of a rank. The idea behind this formula is that the more votes a game has, the more accurate the overall rating and also the more popular the game probably is.

While I was at it, I also updated my script so that the mysql query doesn't have to do the calculation each time. Basically the numbers are updated only once a day rather than with every page view (which helped speed up the RGR search which contributes to what I talk about below).

On the other end of the spectrum are the bad rated games. For fun, you can see what ended up being considered the "worst" games on Vizzed:
https://www.vizzed.com/p/?page=3286&noHacks=true&sort=best#searchresults
Amazingly, the 5 worst rated games that appear on that page are also considered to be in the top 10 worst games of all time (according to experts and pretty much everyone) so that strengthens my confidence that this new formula is a great new measure of what's considered the "best" and "worst" games of all time.

I'll probably put together a similar formula for other pages of the site where things are ordered by "best" (such as the index page of the Video Game Music Room).


Site Optimized Again
I've optimized portions of the retro game room, did some database optimization and altered some settings on the server and also updated a few things on the server. The result:
Vizzed.com index = 1.5 x faster
RGR Index = 2 x faster
Game Pages = 1.5 x faster
RGR Search = 1.5-2 x faster

I've got a few more things that I plan to do within the next few days which will increase site speeds even more.
New 'Best' Formula
The old formula for ordering the games based on 'Best' was votes * rating. The new formula is:
(rating-5)*(votes/10)
You can see the results of the new order here:
https://www.vizzed.com/p/?sort=best
It's pretty similar on the first few pages but further pages it changes up a bit. I think this orders things better because there were some average rated games that had a lot of votes that were being ranked high and now this pushes them further down. Having the rating - 5 (where max rating is 10) makes any rating above a 5 considered a positive rating and any rating below a 5 a negative rating which places more emphasis on positive scores (before a bad score would have still been given weight).

The reason having things order by just rating isn't good enough is because a game could have just a few votes where the users all voted the game a 10 but that doesn't mean the game deserves that high of a rank. The idea behind this formula is that the more votes a game has, the more accurate the overall rating and also the more popular the game probably is.

While I was at it, I also updated my script so that the mysql query doesn't have to do the calculation each time. Basically the numbers are updated only once a day rather than with every page view (which helped speed up the RGR search which contributes to what I talk about below).

On the other end of the spectrum are the bad rated games. For fun, you can see what ended up being considered the "worst" games on Vizzed:
https://www.vizzed.com/p/?page=3286&noHacks=true&sort=best#searchresults
Amazingly, the 5 worst rated games that appear on that page are also considered to be in the top 10 worst games of all time (according to experts and pretty much everyone) so that strengthens my confidence that this new formula is a great new measure of what's considered the "best" and "worst" games of all time.

I'll probably put together a similar formula for other pages of the site where things are ordered by "best" (such as the index page of the Video Game Music Room).


Site Optimized Again
I've optimized portions of the retro game room, did some database optimization and altered some settings on the server and also updated a few things on the server. The result:
Vizzed.com index = 1.5 x faster
RGR Index = 2 x faster
Game Pages = 1.5 x faster
RGR Search = 1.5-2 x faster

I've got a few more things that I plan to do within the next few days which will increase site speeds even more.
The Owner
Owner, Developer, Advertiser, etc
Founder, Mod, Investor


Affected by 'Carpal Tunnel Syndrome'

Registered: 12-06-04
Location: Wisconsin
Last Post: 23 hours
Last Active: 2 min.

(edited by Davideo7 on 03-12-17 08:40 AM)     Post Rating: 4   Liked By: asdren, deggle, Lexatom, thing1,

03-12-17 08:14 PM
Uzar is Offline
| ID: 1332319 | 22 Words

Uzar
A user of this
Level: 140


POSTS: 5900/6433
POST EXP: 345123
LVL EXP: 32521614
CP: 25933.5
VIZ: 555693

Likes: 0  Dislikes: 0
This is an awesome new feature. Great work as always, David!!

Also, Action 52 is currently the worst game on Vizzed.
This is an awesome new feature. Great work as always, David!!

Also, Action 52 is currently the worst game on Vizzed.
Vizzed Elite
I wonder what the character limit on this thing is.


Affected by 'Laziness Syndrome'

Registered: 06-03-13
Location: Airship Bostonius
Last Post: 1900 days
Last Active: 1871 days

03-12-17 08:30 PM
zanderlex is Offline
| ID: 1332324 | 14 Words

zanderlex
dark mode
Level: 263


POSTS: 23180/28312
POST EXP: 1930095
LVL EXP: 295917229
CP: 156516.0
VIZ: 12362157

Likes: 0  Dislikes: 0
Davideo7 : could this have been the cause of the sites view counter to reset?
Davideo7 : could this have been the cause of the sites view counter to reset?
Vizzed Elite
Sergei's Mustache


Affected by 'Laziness Syndrome'

Registered: 09-25-13
Location: Inaba
Last Post: 94 days
Last Active: 6 days

03-13-17 06:07 PM
Cyro Xero is Offline
| ID: 1332381 | 67 Words

Cyro Xero
Level: 110


POSTS: 3168/3193
POST EXP: 241888
LVL EXP: 14386377
CP: 2389.3
VIZ: 714746

Likes: 0  Dislikes: 0
Wow, the view counter did reset. I wouldn't have noticed it.

I hadn't noticed the site getting slow, but then I only started being active again last month.

The rating update is a good change. I never really look at the game ratings, but indeed having it the old way probably did or could have thrown people off about just how good or bad a game was.
Wow, the view counter did reset. I wouldn't have noticed it.

I hadn't noticed the site getting slow, but then I only started being active again last month.

The rating update is a good change. I never really look at the game ratings, but indeed having it the old way probably did or could have thrown people off about just how good or bad a game was.
Vizzed Elite
Funder
Record holder: Posted from 3 different continents in 24 hours- Sep. 27, 2010


Affected by 'Laziness Syndrome'

Registered: 11-22-06
Location: Minnesnowta
Last Post: 2445 days
Last Active: 1041 days

Links

Page Comments


This page has no comments

Adblocker detected!

Vizzed.com is very expensive to keep alive! The Ads pay for the servers.

Vizzed has 3 TB worth of games and 1 TB worth of music.  This site is free to use but the ads barely pay for the monthly server fees.  If too many more people use ad block, the site cannot survive.

We prioritize the community over the site profits.  This is why we avoid using annoying (but high paying) ads like most other sites which include popups, obnoxious sounds and animations, malware, and other forms of intrusiveness.  We'll do our part to never resort to these types of ads, please do your part by helping support this site by adding Vizzed.com to your ad blocking whitelist.

×