Updating records in dataset


A feature of Carto DB that makes it stand out from most other mapping platforms out there is the ability to create maps and build applications on top of data that grows and changes.The dynamic nature of the Carto DB stack is what makes it such a fun and powerful platform for so many of our users.



If you can’t tell, our UPDATE just got really slow!If you are regularly updating hundreds or thousands of records, this just isn’t going to be a fun process.The same operation can be rewritten to scan the table only once while joining it against the set of new values: Pretty cool, right?So instead of three table scans, we have reduced it down to only one.