User avatar
jjjukebox
Is there life beyond myServer?
Is there life beyond myServer?
Posts: 1026
Joined: Sat May 22, 2004 10:54 pm
Location: Toronto
Contact: Send private message

Compacting Database

Sun Dec 19, 2010 3:30 pm

I recently was doing a system backup and noticed that commands.mdb had creeped up to 1.8GB. I did a compact and repair and reduced it to 7.5mb. It contains just under 40,000 variables and 2500 command maps.

Is there any tool available to automatically compact the database without manually opening it in access and doing a compact& repair?

Thanx
J.J. Jukebox
Member

bigDvette
Expert
Expert
Posts: 718
Joined: Thu Oct 12, 2006 1:19 pm
Contact: Send private message

Re: Compacting Database

Sun Dec 19, 2010 3:43 pm

There is a tool by Mircrosoft called http://support.microsoft.com/kb/295334 , but I haven't tried it.

Also, I think the next version of MLServer is going to use SQL server from what I think I remember hearing so it may be irrelevant soon.

User avatar
jjjukebox
Is there life beyond myServer?
Is there life beyond myServer?
Posts: 1026
Joined: Sat May 22, 2004 10:54 pm
Location: Toronto
Contact: Send private message

Re: Compacting Database

Sun Dec 19, 2010 3:58 pm

Thanx BD

I may as well wait to see what MLS4 looks like as I am sure it is not far out.

Later
J.J. Jukebox
Member

User avatar
DavidL
Founder
Founder
Posts: 11588
Joined: Sat Feb 08, 2003 9:39 am
Location: Metamora, Michigan
Contact: Send private message

Re: Compacting Database

Sun Dec 19, 2010 7:55 pm


User avatar
jjjukebox
Is there life beyond myServer?
Is there life beyond myServer?
Posts: 1026
Joined: Sat May 22, 2004 10:54 pm
Location: Toronto
Contact: Send private message

Re: Compacting Database

Sun Dec 19, 2010 8:06 pm

David,

Dont use MLWMI and that post also states it only does the databases in the MLServer\data directory. Command.mdb is in the root MLServer directory.

Thanx for the reply
J.J. Jukebox
Member

User avatar
AllonisDave
Founder
Founder
Posts: 11497
Joined: Fri Feb 07, 2003 8:56 am
Location: Newport Beach, CA
Contact: Send private message

Re: Compacting Database

Mon Dec 20, 2010 12:11 am

Don't worry about this. MLS4 will make this issue go away.

Return to “MLServer 3”

Who is online

Users browsing this forum: No registered users and 2 guests