June 9, 2003 at 12:01 pm
I am using xp_sendmail in some INSERT, UPDATE, and DELETE triggers. The result set I am including as an attachment is only two small records. From the time xp_sendmail is called until it returns is approximately 9 seconds.
I've set up an e-mail account through Outlook as instructed and the e-mails are being sent as advertised. Why is the performance so dismal?
Regards,
Cliff
June 12, 2003 at 8:00 am
This was removed by the editor as SPAM
June 12, 2003 at 9:16 am
Did you try to send the same e-mail using Outlook? The behavior is the same?
June 12, 2003 at 9:29 am
Yes, I tried sending the same e-mail through Outlook and it did not exhibit the same behavior.
I have since developed my own extended procedure to send an e-mail. It executes normally (no noticable delay). The difference is that it bypasses Outlook. It must have something to do with the Outlook configuration but I'm unaware what it might be.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply