xp_sendmail questions

Results 1 to 3 of 3

Thread: xp_sendmail questions

  1. #1
    neils Guest

    Default xp_sendmail questions

    Hello,<BR><BR>I&#039;m working on a mailing list system and I&#039;m planning on sending the messages using the xp_sendmail procedure in SQL Server 7.0.<BR><BR>My only concern is with the performance of that procedure. If I loop through a list of recipients (probably 2000 to 3000) of them, is this going to kill my SQL server performance wise?<BR><BR>Anyone have experience with something like this?

  2. #2
    Join Date
    Dec 1969

    Default RE: xp_sendmail questions

    It will depend on the configuration of your SQL Server and how many processors you have... If you have the load distributed over enough processors or a cluster, it will fine. How much other volume do you get on your SQL Server? <BR><BR>I don&#039;t know if this is an option for you, considering your IIS setup, but have you thought about using the "CDONTS.NewMail" object?

  3. #3
    neils Guest

    Default RE: xp_sendmail questions

    Unfortunately we don&#039;t have access to the CDONTS objects, so that&#039;s not an option for me.<BR><BR>I&#039;ll do some testing on the SQL server and see how it handles this load, if it doesn&#039;t work out I guess I&#039;ll find a different option.<BR><BR>Thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts