> Second, the one biggest and most important performance issue > when using > Imail with an external database and SQL is NOT the Imail box, > it's the SQL > box and it's network connectivity. I agree with most of what you said and would also add the importance of creating Indexes on large SQL tables. ( A clustered index on USERID seems to make a worth while difference as all searches are based on this parameter). However with a large set of users within a domain the biggest problem I have seen is that the current DLL only uses one SQL server connection per domain. When this is changed to open a new connection for each Auth and Getuser method call you get ~ 2x the authentications per sec when really driving it (and the SQL server definitely then becomes the limit), unfortunately this does increase the load on the SQL server so if it is already struggling it will get worse. Also by changing the cursor type to forward only on the Authorize and GetUser methods on the dOdbcDatabase helps reduce the time it takes for SQL server to answer a request. Steve Steven Moore Internet Development Engineer Research Machines +44 1235 823522 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: 07 March 2001 15:48 > To: [EMAIL PROTECTED] > Subject: Re: [IMail Forum] For those using MS SQL <snip> Standard Disclaimer: This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the information only for the intended purpose. Internet communications are not secure and therefore RM does not accept legal responsibility for the contents of this message. Any views or opinions presented are only those of the author and not those of RM. If this email has come to you in error please delete it and any attachments. Please note that RM may intercept incoming and outgoing e-mail communications. 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/
