Regarding the tinyint and int and the like issue: I disagree. I'll give
you two good reasons:
1. An 8 GB flash drive costs $29. A 500 GB backup drive costs 75$.
Saving space should be the least of our concerns. Indeed, I'd prefer
creating a data warehouse, which would mean heaving denormalized data.
2. If you do sum(wins) on a tinyint, some DBMS will keep the data type as
tinyint. You will get into overflow situations.
Whatever performance issues you can possibly gain pales in comparison to
potentially corrupt output.
Tom