* This is the modus mailing list * Yes, you would still allow dynamic growth.
Dynamic growth is key to letting your database expand as you store more and more data. As the amount off SPAM is growing each day we are quarantining more and more, resulting in more data being stored in SQL. Allowing this growth ensures that the system will continue to function providing there is enough disk storage. Auto-Shrink was turned off by default as it does impact performance slightly as the database will be periodically checked for unused space. In normal operating environments databases tend to continuously grow whilst hardly ever decreasing in size. In addition reducing the size off the database files requires more processing to take place to dynamically grow the database and in most databases only a few records are deleted resulting in very small amounts off disk space changes. Therefore, the best default was to leave this option off. I should add in most databases I leave the Auto-Shrink option off, however for the Modus Mail database we did have this set on for a while. We subsequently turned it off to improve performance, as we found that whilst the database would shrink periodically it needed to re-grow and hence any performance gain by shrinking the database was lost when it came to having to grow it. Regards, Suneel. -----Original Message----- From: Rick [mailto:[EMAIL PROTECTED] Sent: 29 October 2003 23:27 To: [EMAIL PROTECTED] * This is the modus mailing list * Suneel, This is what happens when someone is barely able to install SQL and run the script to create the quarantine db. Doesn't know enough to be dangerous, but knows so little he is REALLY dangerous. For example, a stupid question, do you still allow the dynamic growth when you have the auto-shrink enabled? Thanks, Rick ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
