Optimize Database?

I recently deleted a few thousand emails to speed things up in Emclient (POP3). But I believe my backup directory has not changed in size, and it still takes several minutes to refresh and for new messages to download. Is there a utility or something I can run to optimize the database to speed things up?

See this thread below.

Note: - Before running the database utility in the link above, backup eM Client via “Menu / Backup” incase you need to restore for any reason. You can see when the backup is complete via show operations in the dropdown next to refresh.

Also close eM Client before running the utility.

I have tried clicking on the link in the thread that you mentioned, to download the executable repair utility. Nothing is happening, and I get a small 7K file downloaded which does nothing. Is there a better link to download this utility?

The utility is meant for older versions of eM Client.

In more recent versions, do the following:

Close eM Client and open a Windows Command Prompt. Not a powershell, but a command prompt.

Paste in this command including the leading "

"C:\Program Files (x86)\eM Client\MailClient.exe" /dbrepair /rebuildall

When that is done, restart eM Client.

This doesn’t work for me. When I enter the command and press return, emclient starts up, saying it didn’t shut down properly, checking for corrupted database, etc. When the checks are finished and emclient opens, I do another backup but the backup is the same size as before.

I’ve repeated the process twice, with the same result.

I realise this thread is fairly old, so maybe there’s a different way now? Thanks.

Ed, I was also trying to figure out how to compress my main database after removing a lot of emails and followed the same instructions from Gary, above. I also saw the eM Client window reporting that it had not shut down properly and checking for a corrupted database. I think this is the intended process that the command line instruction runs. In my case, the eM Client folder increased in size once the utility had completed (!) On closer inspection, I noted that the database check had created backup files of every database file in the folder (filename extension .dat-bak) at the top level and in every sub-folder containing a database. After checking that I could still open eM Client and that all my emails appeared to be present, I moved all of these backup files out of their respective folders and will delete them altogether in a week or so, if no problems are discovered. Removal of the backup files (copies of the database before the databases were rebuilt and compressed) reduced the size of my eM Client folder to the size expected.

In summary, the process proposed by Gary worked for me and triggered the database check/rebuild that you described, but produces backup files in the same folders as the original files. You need to remove these (search for all .dat-bak files in the eM Client folder) in order for your folder size to decrease. I was running this on v10, so the process is still valid.

Which eM Client folder, there are many in the \AppData\Roaming\eMClient tree.

And is there an option to back up without continously creating these .bak files which are huge?

SO… I had a back up directory size of about 26GB. Last month, I deleted more than 50% of the emails in my INBOX, and I now have about 25,000 emails remaining. I then did another back up, deleted the excess .dat-bak files, and yet another back up after that. I am still at a back up size of 26GB.

Why would this be?

I also deleted a lot of mails, emptied all trashes an run the command
MailClient.exe /dbrepair /rebuildall
After deleting the bak-files the required space in the folder(s) of eM Client went down as expected.

The backup-file reflects more or less the space I use on the mailserver itself for my mails.