Take the 2-minute tour ×  I want to build a MySQL database for
storing the ranking of a game every 1h. Since this database will
become quite large in a short time, I figured it's important to
have a proper design. Therefor some advice would be gratefully
appreciated.  In order to keep it as small as possible, I
decided to log only the first 1500 positions of the ranking.
Every ranking of a player holds the following values: ranking
position, playername, location, coordinates, alliance, race,
level1, level2, points1, points2, points3, points4, points5,
points6, date/time  My approach was to simply grab all values of
each top 1500 player every hour by a php script and insert them
into the MySQL as one row. So every day the MySQL will grow
36,000 rows. I will have a second script that deletes every row
that is older than 28 days, otherwise the database would get
insanely huge. Both scripts will run as a cronjob.  The
following queries will be performed on this data:    • The most
important one is simply the quer