Hi,

We are experiencing performance issue with MonetDB when running UPDATE.

We have a table with 1M rows and 3.000 columns. All columns except primary_id are FLOAT type.

When I execute series of these statements the performance on first 30-35 statements is quite acceptable (less then 1s) but then suddenly it gets really slow. One UPDATE takes 30 seconds or more. After next 5-10 statements the performance decreases and one UPDATE takes 1 minute or longer. We run this with AutoCommit. The behavior is very persistent.

UPDATE table SET column=column+1 WHERE primary_id='e1a7d7c7204c292e56e942dbdad118d3' ;

Would you say MonetDB is not suitable for bulk UPDATE operations?

Thanks, Vlad