[MonetDB-users] Series UPDATE statements will significantly decrease server performance
13 Apr
2011
13 Apr
'11
8:12 a.m.
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
5008
Age (days ago)
5008
Last active (days ago)
0 comments
1 participants
participants (1)
-
Vladimir Vlach