Re: Storing sensor data

Option 1 is about somewhere between 2 and 3 times more work for the database than option 2.

Do you need every sensor update to hit the database?  In a situation like this I'd be tempted to keep the current values in the application itself and then sweep them all into the database periodically.  If some of the sensor updates should hit the database faster, you could push those in as you get them rather than wait for your sweeper.  This setup has the advantage that you c0an scale up the number of sensors and the frequency the sensors report without having to scale up the disks.  You can also do the sweeping all in one transaction or even in one batch update.