Solved

time out expired when execute stored procedure

Posted on 2008-10-23
3
827 Views
Last Modified: 2012-05-05
hi guys i have a stored procedure that basically has a select statement. i know my table is very big it could be well more than 1million rows. but the statement only runs for 2 mintues and already i get a time out. even though i set my timeout very high. here is the code for the function and the time out. please help me if you know what i did wrong. thank you very much
<httpRuntime executionTimeout="100000000" />  this is in the web.config
 

this below is in my default.aspx.vb .

query parameter is just a select like select * from table1.

    Public Function GetDataTable(ByVal query As String) As DataTable
 

        Dim adapter1 As New SqlDataAdapter

        adapter1.SelectCommand = New SqlCommand(query, allfunctions.SQLConnection)

        Dim table1 As New DataTable

        allfunctions.SQLConnection.Open()

        Try

            adapter1.Fill(table1)

        Finally

            allfunctions.SQLConnection.Close()

        End Try

        Return table1

    End Function

Open in new window

0
Comment
Question by:StewSupport
  • 2
3 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 22792578
Try also setting the SelectCommand.Timeout value --

adapter1.SelectCommand.CommandTimeout = 100000000
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 22792579
Other place to check is the IIS script timeout.
0
 
LVL 26

Expert Comment

by:Anurag Thakur
ID: 22792763
what kind of time out you are talking about (there are 3 kinds)
1. Sessiontimeout controlled by IIS
2. IIS thread execution timeoout
3. DB Command timeout

1. Can be controlled through timeout in the following (in seconds)
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="2000" />

2. Can be controlled by setting the executionTimeout (in seconds) (I think u might need to set this)
<httpRuntime executionTimeout="XXX" />

3. Can be controlled by setting the Command Timeout to 0 (means infinite)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now