Statuses

Storage statistics, update rates

In Uncategorized on May 28, 2010 by salvadormrf

We have 327.735 records in database, with total size of 27.1 Megabits, which gives an average of 10.84 bytes per record in database.
3552051.2 (bytes)/327735 (records)  = 10.84bytes per record
So when selecting the upload rate for sensors, we should keep in mind this values.
Time to fit one GigaByte
Interval Records days years
Second 1 1146.65 3.14
10 114.66
0.31
100 11.47
0.03
1000 1.15 0
Minute 1 68798.82 188.49
10 6879.88 18.85
100 687.99 1.88
1000 68.8 0.19
Hour 1 4127929.15 11309.39
10 412792.92 1130.94
100 41279.29 113.09
1000 4127.93 11.31

If you have a sensor with the upload rate at 1 seconds, in 3.14 years the sensor data will take 1GB of space

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: