Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sq2
Starting Member
11 Posts |
 Posted - 2010-07-18 : 08:19:59
|
| I have 4 players (A, B, C and D) competing in some ongoing competitionI would like to update their scores in a db over time and output these by selecting from db order by score to show who's currently on top, etc.however, perhaps one day i would like to show a history of these players and their progress through time... so this leads to inserting new records with playerId, currentScore, dategreat. this all seems fair, now to get any players history i can select by playerId order by date... and to show who's currently on top or who was where at any date i can select unique by date, perhaps a < > date request is required.so, a few questions:- if you scale this idea to 100s of players, playing daily over a couple of years, this db table will grow quite a lot, but is this sort of expansion what sql is built to deal with? (note, i'm using mysql but don't think it matters that much)- not all players will play all the time, i know how to get a unique record for A where date is highest, but how to get a unique record for A, B, C and D where each is the latest date?sq2 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-18 : 09:31:50
|
| SQL can handle much more. I don't know if you are talking about MS SQL Server or MySQL or just SQL on general?I can give you an example than we have on daily basis more than 1 milion transactions and this means more than 1,5 milion records on daily basis (multiply this by days in one year) and SQL handles it very good. also depends on your hardware, configurations, software. |
 |
|
|
sq2
Starting Member
11 Posts |
Posted - 2010-07-18 : 11:05:53
|
| So i shouldn't be concerned with how many rows i add to a database in respect to making queries on it?selecting the top ten players with the latest date won't be harder with a million rows compared to 10 rows? |
|
|
|
|
|
|
|
|
Score changing daily + history