| T O P I C R E V I E W |
| ComZiz |
Posted - 22 Sep 2013 : 23:22:37
What exactly compacting do?
Every time it reduces the file size significantly. I'm wondering what kind of inputs it removes from the database?
Thanks in advance |
| 4 L A T E S T R E P L I E S (Newest First) |
| yan00s |
Posted - 28 Sep 2013 : 12:25:28
quote:
Originally posted by ComZiz
Thank you so much for your answer.
but this leaves me with a question; "Why there are unused empty spaces created in the first place? =D
Try to see the database file like a drive in a drive. There's always something going on on a drive. ;) Compact and Repair is (a bit) like defragmenting. |
| Alessio Viti |
Posted - 25 Sep 2013 : 11:19:36
I exactly do not know why, I think that MS Access engine create this unused space, this is why there is this function inside MS Access.
Ale |
| ComZiz |
Posted - 23 Sep 2013 : 22:34:09
Thank you so much for your answer.
but this leaves me with a question; "Why there are unused empty spaces created in the first place? =D |
| yan00s |
Posted - 23 Sep 2013 : 22:30:19
It's a bit like house keeping: the process just tries to get rid of unused empty space within the database file. It doesn't actually touch your "real" data. Also, it's a functionality provided not by XMM but MS Access.
(Technically it's a bit more complex but hopefully this helps nevertheless to not worry about it.) |
