an advantage of using an external DB is you can build your web registration logic to incorporate the email reg process in-line with your membership process. i.e. If you require your users to register for an account via the web you simply need to do straight asp/jsp stuff to get the imail required data into SQL or Oracle. I run Imail db for all hosts that do not require registration via web and SQL server for all those that do. If you need some sample asp code let me know.
[EMAIL PROTECTED] ----- Original Message ----- From: "Matthew Dehait" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 7:47 PM Subject: RE: [imail] imail using external SQL database I run it on the same box with about 1300 accounts, and IIS also. No problem. P4 2200, 768 RAM, RAID 5 It's really easy to manage since you can play by SQL Server rules. Matthew Dehait Systems Analyst CORF Services 7272 E. Indian School Rd. Scottsdale, AZ 85251 480.212.4003 -----Original Message----- From: Sanford Whiteman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:37 PM To: rbad @ web-comm . com Subject: Re: [imail] imail using external SQL database > 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 ______________________________________________________________________ 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 ______________________________________________________________________ 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
