Question: How well does Monetdb support incremental updates?
Question for you kind folks. I've tested another open source column-store database (Infinidb)...the query performance was very good, the bulk load performance was good, but where it fell down was on refreshing the data by updating a small percentage of the existing values. Bulk loads processed about 1000 rows/second...updating existing rows processed only about 1 row/second. We have growing 60-70Gb data warehouse, and we don't want to drop and re-load it every night, we want to just apply incremental updates at very short intervals throughout the day (say, every 5 mins).
So, how well will Monetdb handle updates to existing rows in this scenario?
One additional question: Are there any sources of commercial support for Monetdb?
Thanks and best regards,
participants (1)
-
David Sisk