Large Calculations
| From: | Jeff Lewis | Date: | Mon, 30 Jul 2001 17:11:20 +0000 |
| Subject: | Large Calculations | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-60243@lists.php.net to get a copy of this message | ||
I have a mySQL database holding baseball stats and I want to calculate
rankings on these players. Now I'd obviously want this to be as fast as
possible since I go through about 600 players but where is it best to make
them? In the SQL command itself or in PHP?
players need to have at least 100 at bats for this formula to work for them.
There are 6 steps.
1. batting average x .05
2. doubles + triples + HR divided by at bats
3. runs scored divided by at bats
4. rbi's divided by at bats
5. stolen bases divided by at bats
next add up the 5 totals then multiply that total by 200. It's a bse 100
system. a rating over 100 is very good.
Jeff