Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
When data is added to the database, new rows are created which contain all the data. When database is trimmed, data from all the rows that lie within the time frame specified for trimming is removed. But those rows are left there. They are empty and cannot be used again to fill with data. This is where shrinking comes in. It deletes those empty rows left out after trimming. So you free up some actual space only after shrinking and not just after trimming. Keep in mind, one can shrink only after trimming because shrinking will remove only empty rows and trimming will delete data from rows and make them empty.
A scheduled maintenance plan is automatically created and enabled for the ION_Data database which takes care of shrinking and some other tasks. But since a trim task is not enabled by default, shrinking doesn't impact anything until trimming removes data from rows.
When you want to shrink a database, the box that opens shows allocated space in a database and free space. When you click OK, the free space is subtracted from allocated space and that is the remaining database space. Here the free space means empty rows left out by trimming which are empty but still cannot accept any new data.