historical database

DeletedUser

Guest
Im using a form of the script I posted on the forum to gather data from grepolis but now looking to keep a historical record.

http://forum.en.grepolis.com/showthread.php?t=12930

What are others doing to store data making it easily reported on. Im currently only keeping 1 version of the data (database contains 12 tables matching the file formats)

for example report player ATK points for the last 7 days.
 

DeletedUser

Guest
unless anyone else comes up with better.... ive gone with a date stamp on all tables but for database size three tables will only have 7 day history
conquers (1.8Mb * 7 = 12.6Mb)
islands (2.3Mb * 7 = 16.1Mb)
towns (2.1Mb * 7 = 14.7Mb)

Estimates the database will grow around 0.9Mb a day
 
Top