You wrote:
> 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
why don't you calculate the stats every time someone inserts new stats...
you could have a column in your table for the average of the stats you
want.. that way when you want to call them back up all you have to do is get
that one column and save your cpu all that processing power... that's my
tho
2 matches
Mail list logo
