I am writing an application that will poll up to 500 devices every 5
minutes. For this application I need to keep at least 6 months of data. If
I were to use a single record for every update, I would have ~25 million
records. Obviously this is not an ideal solution.
I am interested in getting ideas on how to tackle this. I was thinking that
I would have a table that stored all the values for the current day and a
table for historical data. After 24 hours the data would be averaged into a
daily snapshot and stored in another table. The data from that day would
then be cleared. This would only require ~90k records.
I would appreciate any ideas. I have written a ton of web applications
using mySQL, but have never had to scale above 100k entries :)
Thanks,
Matt
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
