> 1. Are there any negatives to using an EXTERNAL database vs. the > imail DB?
Much slower than native. > (any features that do NOT work once we move to External?) Not anymore--it's pretty much identical, except for the above and some domains-that-start-with-numbers issues. > Are there any positives? Ability to use SQL to add/query userbase. > 1a: How stable is this solution?? As stable as your points of failure. :) > 2. Can SQL server run on the same box as imail? Technically, yes, but SQL needs to be tweaked significantly and you MUST size the box as if it were two servers in one. And you're already choosing the slow (ODBC) method of running IMail. > 3. Can we use SQL for some of our domains and the imail internal db for the rest? > (none of our mail domains are "virtual" -- they all have individual public IP's) Yes. > 4. Can imail "reach out across the internet" to validate users on another SQL server > at a remote location? Geez. Well, there you're talking about link reliability and all that other janky intermediate stuff to worry about. IMail won't care, in a sense--it just asks ODBC for the data, and it's up to ODBC where/how fast to get it. I have seen sites crippled by trying to do ODBC over WAN links--even T1s that seemed okay going in. Realize that IMail requests a singleton SELECT on EVERY incoming message, every authentication request, and also uses ODBC to store preferences. Not recommended. -Sandy ______________________________________________________________________ The HKSI-IMail Admin List is hosted by........ Humankind Systems, Inc. Questions, Comments or Complain like Hell.. mailto:[EMAIL PROTECTED] Message Archive............ http://www.mail-archive.com/[email protected] To Manage your Subscription......... http://humankindsystems.com/lists
