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, -- Dave Sisk | Senior DBA dsisk@lulu.com | www.lulu.com [m] 919-744-1885 _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (1)
-
David Sisk