Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-22 Thread Evgenij Ryazanov
Hello. Standalone MVStore is not a database at all. It's just a copy-on-write key-value storage with multiple maps and optional transactions (with TransactionStore). Of course, you can iterate over MVMap from MVStore by your own code and perform some computations, but I guess it's not that you

Re: [h2] Re: H2 for Raspberry PI and ARM

2019-04-22 Thread Gopalakrishnan Subramani
Hi, Thank you for your write, this is encouraging, using H2 in RaspberryPIs. Will MVStore support aggregate queries? From H2 Website, I read, MVStore is a default storage engine 1.4 onwards. We want to perform aggregation over sum/count,min/max, etc with Window functionalities, I could not find

[h2] Re: H2 for Raspberry PI and ARM

2019-04-22 Thread arief . hasani
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