Solved

time out expired when execute stored procedure

Posted on 2008-10-23
3
831 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 60

Accepted Solution

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

adapter1.SelectCommand.CommandTimeout = 100000000
0
 
LVL 60

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

623 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