Sizing a Year of Tag History on a Raspberry Pi: Sample Rate, Deadband and the Disk Arithmetic
200 tags at one row a second is 17.28 million rows a day, and at the 47 bytes a row that SQLite measured on this machine for a typed, indexed table, that is 814 MB a day and a 32 GB card full in 32 days. The same 200 tags logged on change, with a … Read more