Same here. We only need SQL because we have a CMS system, FTP, and other web apps like CRM that use the same database for authentication. This allows us to have "single sign-on" across all our web apps and integrate it with other parts of our software suite. The "savings" for us is time spent in app development to join user account data with all the other data in our SQL server. ================= Norman Nolasco Advarion Incorporated http://www.advarion.com <http://www.advarion.com/> [EMAIL PROTECTED] 713.859.8886
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Troy D. Hilton Sent: Thursday, May 17, 2007 3:16 PM To: [email protected] Subject: RE: [IMail Forum] SQL or not to SQL We use a SQL database for our users; however we also use WS_FTP Server to authenticate against the same database. The only "real life" advantage I've found is the ability to lookup a user's password instead of having to recreate it. I once heard that there was a performance advantage to SQL but you'd have to have way more accounts than 500 to really see it, IIRC. Troy D. Hilton Serveon, Inc. 302-529-8640 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bonno Bloksma Sent: Thursday, May 17, 2007 3:41 PM To: [email protected] Subject: Re: [IMail Forum] SQL or not to SQL Hi, The only reason to use a SQL database is when one wants to have the user data for other purposes as well. If one has a client database in SQL that is being used for other purposes like finance it might be advantageous to have IMail use the SQL database. Met vriendelijke groet, Bonno Bloksma hoofd systeembeheer tio hogeschool hotelmanagement en toerisme begijnenhof 8-12 / 5611 el eindhoven t 040 296 28 28 / f 040 237 35 20 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] / <http://www.tio.nl> www.tio.nl ----- Original Message ----- From: Dale McDiarmid <mailto:[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, May 17, 2007 9:04 PM Subject: [IMail Forum] SQL or not to SQL Hi... I'll be building a new server small corporate mail server with less than 500 users and a few lists. I'll allow POP and web access. Is it an advantage to go SQL or would the iMail default be fine. I've been running on default for over 10 years without issues. If we did go SQL I'd prefer Oracle, but would consider MS SQL Server or mySQL (if it's an option). Also, would SQL hamper or improve recovery? Any suggestions? Thx, D. To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
