Best way to collect and store data daily?
- by mktb
I have a bunch of statistics: # of users, # of families, ratio user/family, etc.
I'd like to store these daily so I can view this data historically.
However, I'm looking for the most effective way to store this data.
Should I run a cron job that writes to the database DATE: today USERS: 123 FAMILIES: 456 RATIO: 7.89 or whatever? (or should I write multiple rows like DATE: today DATATYPE: users VALUE: 123?)
Or is there another option I can use that is more efficient or more effective?
Thanks!