Reorder records

Here's a git...

Multiple races in a year (8 in 2003!); Numerous teams who may or may not race all or fewer of those races and get some or more points at each, dependent on finishing position.

Just like any racing series really.

I have a results table, with all results and associated points for every race, which, for results pages, is filtered according to the desired race ID then ordered by the "finishing position" column. No problems there.

I also want to do a page for championship standings.

Now, quite simply I can filter the results table for all race IDs of the current year, then find all the results for team 1, add up the points, display them, move to team 2, do the same, etc.

However, this will give a final table ordered by team number and NOT (as I want) by points total and thus position.

The only way I can (so far) think of doing this is for the page to do the above adding up, then write the record back to a new "points total" table (which it would first need to empty from the last time it did this, ie, when someone else looked), repeat for all records, then reopen the "points total" table and order it by the total points.

And about ten days later, the server would finally compile the page and send it off down the wire.

And then fall over when, two seconds later, someone else asked it to do the same thing all over again.

Is there a way of doing this without using all the server resources on a single page?

If not, I'm thinking, include the summation / write to new table thing in an admin section, such that I could do it once, after new race results were added, then use that table for the points total page.

Any suggestions?

Thanks, I'll give that a try.

Sure you just Count the DriverID's up as each Driver that had a race has an entry for each right?
SELECT DriverID, Sum(Points) AS SumOfPoints,Count(DriverID) AS SumofRaces FROM Tablex GROUP BY DriverID