Link to home
Start Free TrialLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

Browser Timeout

Have a .Net web with the code below which returns a simple number which I can add to a string.

The execution time on the code is about 10 seconds to get a number back from the server....very complex select on the other end.

Here's the deal...
I can run this fine in Google Chrome, Safari, and Mozilla...

But IE bombs out with an Execution Timeout message.

Current (our office platforms) is WInXP and IE8

This is the vb that gets the data back
    Private Function getEmailBlastCount(ByVal st As String, ByVal specialty As String, ByVal ckFederal As Boolean) As String
        Dim objConn As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnStr"))
        Dim oCom As New SqlCommand
        oCom.Connection = objConn
        oCom.CommandText = "usp_EmailsForSpecialtyStatesGetCount"
        oCom.CommandType = CommandType.StoredProcedure
        oCom.Parameters.Add(New SqlParameter("@State", SqlDbType.VarChar, 2)).Value = st
        oCom.Parameters.Add(New SqlParameter("@Specialty", SqlDbType.VarChar, 50)).Value = specialty
        oCom.Parameters.Add(New SqlParameter("@Nationwide", SqlDbType.Bit)).Value = ckFederal
        objConn.Open()
        Dim dR As SqlDataReader
        dR = oCom.ExecuteReader()
        dR.Read()

        If dR.HasRows Then
            Return "There are " & dR("emailBlastCount") & " emails in this blast"
        Else
            Return "There are <strong><u>NO</u></strong> emails in this blast"
        End If
        dR.Close()
        objConn.Close()
        objConn.Dispose()
        objConn = Nothing
        oCom = Nothing
    End Function

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Larry Brister

ASKER

Server side

These were commented out for some reason...

        <httpRuntime maxRequestLength="8192" executionTimeout="3600"/>
        <sessionState timeout="180"/>