Hi,
If you could go lower level MVStore is your best friend mate, specially with its blazing fast in-memory. I use it at RPi for around 5 millions log records at around 3000 records/min (i batch write every 1 minute write). Row size is around 60 bytes and with compression my data size is a mere 90MB ish. But you need to go lower level, KV instead of SQL. aggregating 10,000 rows would not be a problem as MVStore has a fast iterator. Now i am not sure about writing 100+/sec to sd card, if i were you and could tolerate some data loss, i would batch write it, say every 10 seconds or so, if you must not loose any data then you still at the mercy of os page cache and fsync mate. My RPi has been running on sandisk sdcard 24/7 for about 2 months plus now without corruption. Cheers -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
