Hi, I was interested in Sandy's response regarding performance as I have never measured the difference.
There are other issues you may wish to be concerned about. I have subscribed to this list and have seen the various "SQL/MySql issues" that people have run into when integrating IMail and SQL. For example, ODBC driver compatibility (MySql) and user authentication (I don't recall if this was fixed in 7.x. Anybody?) There is another option, the one I use, which I don't believe I have ever seen mentioned on this list. Assuming you want an external database for other purposes, it is a simple bookkeeping chore to add/remove/control user settings in both an external database and NT registry. If you do not have coding resources, then this solution is not for you. If you do have coding resources, ASP for example, then you can have an external database and still use NT registry for all IMail accounts. In fact, you can replace all of the IMail admin functions with IIS ASP code using file, database, and registry components. Information about those components is readily available from the IIS Resource Kit. So for example, you can add a user to you accounting database and the IMail server in one step from a "roll-your-own admin web page". Mike ----- Original Message ----- From: "Sanford Whiteman" <[EMAIL PROTECTED]> To: "Kris McElroy" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 6:04 PM Subject: Re: [IMail Forum] Performance ODBC vs. Registry The Registry is faster than SQL. Keep it unless you need to tap into the userbase from elsewhere. Sandy Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
