BinaryWorks.it Official Forum
BinaryWorks.it Official Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 eXtreme Movie Manager 8, 9, 10 Forum
 Information
 Compact & Repair Database		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ComZiz
Junior Member

Turkey
282 Posts
Posted - 22 Sep 2013 :  23:22:37  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

yan00s
Moderator

405 Posts
Posted - 23 Sep 2013 :  22:30:19  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.)
.
Go to Top of Page

ComZiz
Junior Member

Turkey
282 Posts
Posted - 23 Sep 2013 :  22:34:09  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

Alessio Viti
Forum Admin

Italy
9171 Posts
Posted - 25 Sep 2013 :  11:19:36  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
http://www.facebook.com/pages/eXtreme-Movie-Manager/47220214342?ref=mf
Go to Top of Page

yan00s
Moderator

405 Posts
Posted - 28 Sep 2013 :  12:25:28  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
BinaryWorks.it Official Forum © Binaryworks.it Go To Top Of Page
Generated in 0.11 sec. Powered By: Snitz Forums 2000 Version 3.4.07