SQL COMPACT

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
robertog
New user
New user
Posts: 15
Joined: 2020-06-22 18:58

SQL COMPACT

Post by robertog » 2020-06-29 15:01

Hello,
I have a question..., sql compact built in hmailserver is limited 4GB ?
So in case the database reaches limit I can't more send and receive email?

Thank you for your support.

User avatar
johang
Senior user
Senior user
Posts: 291
Joined: 2008-09-01 09:20

Re: SQL COMPACT

Post by johang » 2020-06-29 15:15

robertog wrote:
2020-06-29 15:01
Hello,
I have a question..., sql compact built in hmailserver is limited 4GB ?
So in case the database reaches limit I can't more send and receive email?

Thank you for your support.
answer:

yes
and
yes.......




but:
A MSSQL CE database of 4GB can hold references to about 10 million email messages.
the emails are stored in a DATA directory in your filesystem,
the references of the "name" and "storage path" of an email is stored in database


.
___________________________________________________________end of the line
spam filter appliance gateway: www.mailcleaner.org

robertog
New user
New user
Posts: 15
Joined: 2020-06-22 18:58

Re: SQL COMPACT

Post by robertog » 2020-06-29 15:21

THANK YOU!! so much for this swift reply..

bye

User avatar
jim.bus
Senior user
Senior user
Posts: 425
Joined: 2011-05-28 11:49
Location: US

Re: SQL COMPACT

Post by jim.bus » 2020-07-01 05:59

You would be wise to not use the Compact Database incorporated into hMailServer in my opinion. But rather use something like MySQL or Maria DB. These databases will handle much greater volume and ready for a production environment is my understanding. My understanding was the Compact Database in hMailServer was more for getting you up and operational but if you use for instance MySQL you shouldn't have to worry about the size limitation.

When I first started using hMailServer and a novice at email, I ruled out using the Compact Database as I wanted something that I would not have to worry about having to later on migrate to a better Database so I chose MySQL.

User avatar
jim.bus
Senior user
Senior user
Posts: 425
Joined: 2011-05-28 11:49
Location: US

Re: SQL COMPACT

Post by jim.bus » 2020-07-01 06:37

Additional information on MSSQL CE. There are other drawbacks to using MSSQL CE. This also was a reason I chose to use MySQL. See this link below:

https://www.hmailserver.com/documentati ... ase_engine

Post Reply