The Ultimate Guide to High Availability with MariaDB

Comments - UPDATE vs DELETE and INSERT

6 years, 10 months ago David Hall
Re: UPDATE vs DELETE and INSERT [Answer]

You absolutely understand the issue.

For best future query performance, it's better to do an update to keep the same extents. Delete and insert will not necessarily use the same extents. For a table of that size, it would be unlikely to do so. Furthermore, delete can leave "holes" in your data. ColumnStore does not reuse deleted space within an active extent.

 
6 years, 10 months ago Mike Thibodeau
Re: UPDATE vs DELETE and INSERT

Thank you David.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.