Posted on: 11/10/2012 12:55:05 AM | Views : 409

I have a vb class named systemalerts as below. The email process works it just takes way too long, about 8 to 10 seconds for an email to process. A lifetime for todays users. I use a vendor product UltimateEmail to process and merge the email fields. Just wanted someone that knows more than me to see if any of my code could be slowing the process. If I hard code an donid into the sproc it takes less than a second to complete, so I think it's my code. Imports Microsoft.VisualBasic Imports System.Data Imports System.Data.SqlClient Imports Karamasoft.WebControls.UltimateEmail Public Class SystemAlerts Public Shared Sub SendAlert(ByVal intDon_ID As Int32) Dim mailMerge As New MailMerge mailMerge.IsBodyHtml = True Dim Row As DataRow Dim DS As New DataSet Dim dt As DataTable Dim ConnectStr As String = _ ...

Go to the complete details ...